Coffee
Tables (3)
Menu
- m_name — varchar(50) — Primary key — NOT NULL
- price — int — NOT NULL
- star — int
orderc
- q_seq — seq — Primary key — NOT NULL
- m_name (m_name2) — varchar(50) — Foreign key → Menu.m_name — NOT NULL
- u_id (id2) — varchar(100) — Foreign key → user.u_id — NOT NULL
- o_date — date — NOT NULL
- size — int
user
- u_id — varchar(100) — Primary key — NOT NULL
- u_name — varchar(10) — NOT NULL
- phone — varchar(15) — NOT NULL