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 (가게 사진)