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)