test

Tables (6)

CORNER (코너)

  • CORNER_ID (PK) — NOT NULL — Primary key — NOT NULL
  • CATEGORY (Chinese/korean/japanese)) — NOT NULL
  • CREATE_DATE (생성날짜)
  • UPDATE_DATE (수정날짜)
  • CREATE_ID (생성자 아이디)
  • UPDATE_ID (수정자 아이디)

MENU (Untitled3)

  • MENU_ID (PK) — Primary key — NOT NULL
  • CORNER_ID (PK2) — NOT NULL — Foreign key → CORNER.CORNER_ID — NOT NULL
  • PRICE (가격) — DEFAULT 0
  • IMG_URL (사진 url)
  • IMG_NAME (사진 이름)
  • INTRODUCTION (메뉴정보)
  • MENU_NAME (메뉴이름)
  • CREATE_DATE (생성날짜)
  • UPDATE_DATE (수정날짜)
  • CREATE_ID (메뉴등록자아이디)
  • UPDATE_ID (메뉴업데이트아이디)

MENU_SCHEDULE (Untitled8)

  • LIST_ID (PK) — bigint — Primary key — NOT NULL
  • MENU_ID (FK2) — bigint — Foreign key → MENU.MENU_ID — NOT NULL
  • MEAL_TIME (아침/점심/저녁) — varchar(10
  • CURRENT_START_DATE (판매 날짜) — datetime
  • CREATE_DATE (생성날짜) — datetime
  • UPDATE_DATE (수정날짜) — datetime
  • CREATE_ID (등록자아이디) — varchar(10)
  • UPDATE_ID (수정자아이디) — varchar(10)

ORDER (월별 파티션으로)

  • ORDER_ID (PK) — Primary key — NOT NULL
  • USER_ID (FK) — Foreign key → USER_ACCOUNT.USER_ID — NOT NULL
  • LIST_ID (FK2) — Foreign key → MENU_SCHEDULE.LIST_ID — NOT NULL
  • CREATE_DATE (생성날짜) — datetime
  • ORDER_TIME (주문 시간(breakfast/lunch/dinner)) — varchar(10)
  • UPDATE_DATE (수정날짜) — datetime
  • CREATE_ID (메뉴등록자아이디) — varchar(10)
  • UPDATE_ID (메뉴업데이트아이디) — varchar(10)

USER_ACCOUNT (Untitled)

  • USER_ID (PK) — Primary key — NOT NULL
  • ID (아이디) — varchar(10)
  • PASSWORD (비밀번호) — varchar(100)

USER_INFO (Untitled5)

  • USER_ID (PK) — Foreign key → USER_ACCOUNT.USER_ID — NOT NULL
  • USERNAME (회원이름) — varchar(10)
  • PHONE (전화번호) — char(11)
  • EMAIL (이메일) — varchar(100)
  • ROLE (회원타입) — vharchar(10)
  • ACTIVATED (탈퇴여부(Y,N)) — char(1)
  • CREATE_DATE (생성날짜) — datetime
  • UPDATE_DATE (수정날짜) — datetime
  • CREATE_ID (메뉴등록자아이디) — varchar(10)
  • UPDATE_ID (메뉴업데이트아이디) — varchar(10)