customer
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | varchar(3) | No | ||||
| name | varchar(15) | No | ||||
| age | char(2) | No | ||||
| gender | char(1) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 10 | A | No |
empcontact
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id | varchar(5) | Yes | NULL | |||
| street | varchar(10) | Yes | NULL | |||
| city | varchar(20) | Yes | NULL | |||
| cell | varchar(10) | Yes | NULL |
empdetail
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id | varchar(5) | Yes | NULL | |||
| name | varchar(20) | Yes | NULL | |||
| desgn | varchar(20) | Yes | NULL | |||
| salary | int(5) | Yes | NULL |
flightinfo
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| flightno | varchar(8) | No | ||||
| fromcity | varchar(10) | No | ||||
| tocity | varchar(10) | No | ||||
| fare | int(11) | Yes | NULL |
onflight
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | varchar(3) | No | ||||
| flightNo | varchar(8) | No | ||||
| flightdate | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 9 | A | No |