riverviewcard
commentcard
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 0 | A | No |
page_permissions
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 6 | A | No |
ratings
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 0 | A | No |
tbl_admin
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 3 | A | No |
tbl_daily_cash
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 |