DeliDeli

Tables (4)

MENU

  • menuseq (Key) — varhcar2(30) — Primary key — NOT NULL
  • restid (Key2) — varchar2(30) — Foreign key → RESTAURANT.restid — NOT NULL
  • menuname (Field) — varhcar2(100)
  • menucomment (Field2) — varchar2(500)

RESTAURANT

  • restid (Key) — varchar2(30) — Primary key — NOT NULL
  • ceoid (Key2) — varchar2(20) — Foreign key → USER.userid — NOT NULL
  • address (Field) — varchar2(100)
  • restname (Field2) — varchar2(30)
  • restcomment (Field3) — varchar2(500)

REVIEW

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

USER

  • userid (Key) — varchar2(20) — Primary key — NOT NULL
  • userpw (Field) — varchar2(30)
  • phonenum (Field2) — varchar2(15)
  • address (Field3) — varchar2(100)
  • birthdate (Field4) — date
  • authority (Field5) — varchar2(10)
  • email (Field6) — varchar2(100)
  • gender (Field7) — varchar2(6)