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)