heeorder
Tables (5)
menu
- menu_seq (menu_seqn) — number — Primary key — NOT NULL
- menu_title_seq — number — Foreign key → menu_category.menu_category_seq — NOT NULL
- store_seq — number — Foreign key → store.store_seq — NOT NULL — sequence로 관리
- menu_name — char(300) — NOT NULL
- menu_description — char(3000)
- menu_price — number — NOT NULL
- menu_state — number — NOT NULL — 0: 품절 / 1: 판매중
- menu_img — varchar(300)
menu_category
- menu_category_seq — number — Primary key — NOT NULL
- menu_category — varchar(30) — NOT NULL
order
- order_no — number — Primary key — NOT NULL — sequence로 관리
- store_seq — number — Foreign key → store.store_seq — NOT NULL — sequence로 관리
- create_at — date — NOT NULL
- order_state — number — 1: 주문 완료 (확인중)/ 2: 조리중 / 3:완료(픽업) /4:취소
- customer_phone — char(10) — 카카오알림 기능
order_item
- order_no — number — Foreign key → order.order_no — NOT NULL — sequence로 관리
- quantity — number — NOT NULL
- menu_seq (menu_seqn) — number — Foreign key → menu.menu_seq — NOT NULL
store
- store_seq — number — Primary key — NOT NULL — sequence로 관리
- store_id — varchar(30) — NOT NULL
- store_pw — char(300) — NOT NULL
- store_name — char(300) — NOT NULL
- enroll_date — char(10) — NOT NULL
- dell_date — char(10)
- store_certificate — char(10) — NOT NULL
- store_level — number — NOT NULL — 가입미승인 : 1 / 가입승인 :2 / 관리자 : 3
- store_logo — varchar(300)