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