final_project
Tables (4)
RESTAURANT (Untitled)
- rno (Key) — int(4) — Primary key — NOT NULL
- name (Field) — char(16)
- opentime (Field5) — int(4)
- closetime (Field6) — int(4)
- menu1 (Field2) — char(16)
- menu2 (Field3) — char(16)
- avgprice (Field4) — int(5)
- sno (Key2) — int(1) — Foreign key → STYLE.sno — NOT NULL
- tpossible (Key3) — char(3) — Foreign key → TICKET.tpossible — NOT NULL
REVIEW (Untitled6)
- rvno (Key) — int(6) — Primary key — NOT NULL
- grade (Field) — int(1)
- description (Field2) — longtext
- rno (Key2) — int(4) — Foreign key → RESTAURANT.rno — NOT NULL
STYLE (Untitled2)
- sno (Key) — int(1) — Primary key — NOT NULL
- name (Field) — char(32)
TICKET (Untitled3)
- tpossible (Key) — char(3) — Primary key — NOT NULL