m-00kie
public sql v1 · immutable| Field | Type | Null | Key | Default | Extra |+------------------+----------------------+------+-----+---------------------+----------------+| ID | int(8) unsigned | | PRI | NULL | auto_increment || START_DATE | datetime | | PRI | 0000-00-00 00:00:00 | || END_DATE | datetime | | PRI | 0000-00-00 00:00:00 | || IS_RECURRING | smallint(1) unsigned | | | 0 | || Mo | smallint(1) | | | 0 | || Tu | smallint(1) unsigned | | | 0 | || We | smallint(1) unsigned | | | 0 | || Th | smallint(1) unsigned | | | 0 | || Fr | smallint(1) unsigned | | | 0 | || Sa | smallint(1) unsigned | | | 0 | || Su | smallint(1) unsigned | | | 0 | || DRESS_CODE | varchar(255) | | | 0 | || SERVICE_CATEGORY | varchar(255) | YES | | 0 | || SERVICE_TYPE | int(8) | | PRI | 0 | || TITLE | varchar(255) | | | | || LOCATION | int(8) | | PRI | 0 | || LINKID | varchar(50) | | PRI | | || PARTICIPATORS | text | YES | | NULL | || COMMENTS | text | YES | | NULL | || DATE | datetime | YES | | NULL | || CREATEDBY | int(8) | | PRI | 0 | || FULL | int(2) | | | 0 | || NTERPS | int(3) | | | 0 | || AUDIENCE_SIZE | varchar(50) | | | 0 | || ATTACHMENTS | varchar(255) | YES | | NULL | || JOBID | varchar(255) | YES | | NULL | || INVOICEID | int(11) | | | 0 | || INVOICEDATE | datetime | YES | | NULL | || PRAC_NEEDED | int(2) | | | 2 | || FLAG | int(2) | | | 0 | || DIFFERENTIAL | varchar(6) | | | 0.00 | || MODIFIED | int(11) | YES | | NULL | || MODIFIEDBY | int(11) | | PRI | 0 | || F_MILEAGE | varchar(6) | | | 0.00 | || F_PARKING | varchar(6) | | | 0.00 | || F_AIRFARE | varchar(6) | | | 0.00 | || F_DIFFERENTIAL | varchar(6) | | | 0.00 | || F_MISC | varchar(6) | | | 0.00 | || C_MILEAGE | tinyint(1) | | | 0 | || C_AIRFARE | tinyint(1) | | | 0 | || C_PARKING | tinyint(1) | | | 0 | || C_MISC | tinyint(1) | | | 0 | || MILEAGE_RATE | varchar(255) | | | .3650 | |+------------------+----------------------+------+-----+---------------------+----------------+43 rows in set (0.00 sec)