aa

Tables (3)

crew (CopyOfUntitled)

  • 직원번호 (crewid) — varchar2(200) — Primary key — NOT NULL
  • 직원명 (crewname) — varchar2(100)

menu (Untitled)

  • 메뉴번호 (menuid) — varchar2(200) — Primary key — NOT NULL
  • 직원번호 (crewid) — varchar2(200) — Foreign key → crew.직원번호 — NOT NULL
  • 메뉴이름 (menuname) — varchar2(100)
  • 가격 (price) — int(11)

user (CopyOfCopyOfUntitled)

  • 회원번호 (userid) — varchar2(200) — Primary key — NOT NULL
  • 회원이름 (username) — varchar2(100)
  • 포인트 (point) — int(11)