bistro
commentcard
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| guest_name | varchar(255) | No | ||
| cell_number | varchar(15) | No | ||
| server_name | varchar(255) | No | ||
| food_rating | int(11) | No | ||
| environment_rating | int(11) | No | ||
| servers_rating | int(11) | No | ||
| suggestion | text | Yes | NULL | |
| created_at | timestamp | No | current_timestamp() | |
| post_date | date | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
page_permissions
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| user_id | int(11) | No | ||
| page | varchar(255) | No | ||
| can_access | tinyint(1) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
ratings
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | varchar(50) | No | ||
| star_name | varchar(10) | No | ||
| message | varchar(255) | No | ||
| rating | int(11) | No | ||
| post_date | date | Yes | curdate() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 15 | A | No |
restaurantinfo
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| Title | varchar(255) | No | ||
| Address | varchar(255) | No | ||
| Logo | blob | Yes | NULL | |
| Post_Date | date | Yes | curdate() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
tbl_admin
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(12) | No | ||
| type | tinyint(4) | No | ||
| user_name | varchar(64) | No | ||
| pword | varchar(100) | No | ||
| name | varchar(100) | No | ||
| varchar(64) | No | |||
| phone | varchar(20) | No | ||
| address | varchar(256) | No | ||
| time_stamp | timestamp | No | current_timestamp() | |
| status | tinyint(4) | No | ||
| post_date | date | No | ||
| post_time | time | No | ||
| last_updated | varchar(36) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
tbl_daily_cash
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| description | varchar(500) | No | ||
| dr | decimal(10,2) | No | ||
| cr | decimal(10,2) | No | ||
| balance | decimal(10,2) | No | ||
| month | varchar(2) | No | ||
| year | varchar(4) | No | ||
| post_date | date | No | ||
| post_time | time | No | ||
| status | tinyint(4) | No | ||
| last_updated | varchar(36) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1821 | A | No |