Final Project
Tables (8)
BOARD (게시판)
- BOARD_ID — Primary key — NOT NULL
- CUSTOMER_ID (CUSTOMER ID) — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
- BOARD_TITLE (게시물 제목)
- BOARD_CONTENT (게시물 내용)
- BOARD_PICTURE (게시물 사진)
CUSTOMER (고객)
- CUSTOMER_ID (CUSTOMER ID) — Primary key — NOT NULL
- CUSTOMER_NAME (이름)
- CUSTOMER_LOGINID (로그인ID)
- CUSTOMER_PASSWORD (로그인 비밀번호)
- CUSTOMER_E-MAIL (이메일)
- CUSTOMER_MONEY (보유머니)
- CUSTOMER_PREFERMENU (선호음식)
- CUSTOMER_PREFERSTORE (선호가게)
- CUSTOMER_BIRTHDAY (생년월일)
DDIP (띱)
- DDIP_ID — Primary key — NOT NULL
- CUSTOMER_ID (CUSTOMER ID) — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
- ORDER_TBL_ID (ORDER_TBL ID) — Foreign key → ORDER_TBL.ORDER_TBL_ID — NOT NULL
- DDIP_CURRENTCNT (현재 띱 명수)
- DDIP_TOTALCNT (총 띱 명수)
- DDIP_DEADLINE (띱 마감 시간)
- DDIP_PICKUPTIME (띱 수령 시간)
MENU (메뉴)
- MENU_ID — Primary key — NOT NULL
- STORE_ID — Foreign key → STORE.STORE_ID — NOT NULL
- MENU_NAME (메뉴 이름)
- MENU_PRICE (메뉴 가격)
ORDER_MENU (주문 메뉴)
- ORDER_MENU_ID (ORDER_MENU ID) — Primary key — NOT NULL
- ORDER_TBL_ID (ORDER_TBL ID) — Foreign key → ORDER_TBL.ORDER_TBL_ID — NOT NULL
- MENU_ID — Foreign key → MENU.MENU_ID — NOT NULL
- DDIP_ID — Foreign key → ORDER_TBL.DDIP_ID — NOT NULL
- MENU_CNT (메뉴수량)
ORDER_TBL (주문)
- ORDER_TBL_ID (ORDER_TBL ID) — Primary key — NOT NULL
- DDIP_ID — Foreign key → DDIP.DDIP_ID — NOT NULL
- CUSTOMER_ID (CUSTOMER ID) — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
- ORDER_TBL_PLACE (주문 장소)
- ORDER_TBL_TIME (주문 시간)
- DDIP_CURRENTCNT (현재 띱 명수)
- DDIP_TOTALCNT (총 띱 명수)
- DDIP_DEADLINE (띱 마감 시간)
- DDIP_PICKUPTIME (띱 수령 시간)
REVIEW (리뷰)
- REVIEW_ID — Primary key — NOT NULL
- STORE_ID — Foreign key → STORE.STORE_ID — NOT NULL
- REVIEW_CONTENT (리뷰 내용)
- REVIEW_RAING_TASTE (리뷰 맛)
- REVIEW_RAING_AMOUNT (리뷰 양)
- REVIEW_RAING_STATE (리뷰 상태)
- REVIEW_PICTURE (리뷰 사진)
STORE (가게)
- STORE_ID — Primary key — NOT NULL
- STORE_TYPE (가게 종류)
- STORE_NAME (가게 이름)
- STORE_PICTURE (가게 사진)