starbucks

Tables (9)

Board (게시판)

  • bo_idx (PK) — Primary key — NOT NULL
  • sa_idx (PK2) — Foreign key → System_Admin.sa_idx — NOT NULL
  • bo_title (Field)
  • bo_content (Field2)
  • bo_type (Field5)
  • cretaed_date (Field3)
  • updated_date (Field4)

Cart (장바구니)

  • ca_idx (PK) — Primary key — NOT NULL
  • cu_idx (PK2) — Foreign key → Customer.cu_idx — NOT NULL
  • mn _idx (PK3) — Foreign key → Menu.mn _idx — NOT NULL
  • ca_quantity (Field)
  • created_date (Field2)
  • updated_date (Field3)

Customer (회원)

  • cu_idx (PK) — Primary key — NOT NULL
  • cu_account (Field7)
  • cu_password (Field8)
  • cu_name (Field)
  • cu_email (Field2)
  • cu_nick_name (Field6)
  • cu_mobile_number (Field3)
  • created_date (Field4)
  • updated_date (Field5)

Item (상품)

  • it_idx (PK) — Primary key — NOT NULL
  • mn _idx (PK2) — Foreign key → Menu.mn _idx — NOT NULL
  • it_name (Field)
  • it_price (Field2)
  • it_discription (Field3)
  • it_img_url (Field4)
  • created_date (Field5)
  • updated_date (Field6)

Menu (메뉴)

  • mn _idx (PK) — Primary key — NOT NULL
  • sa_idx (PK2) — Foreign key → System_Admin.sa_idx — NOT NULL
  • mn_condition (Field5)
  • mn_category (Field6)
  • mn_type (Field7)
  • created_date (Field)
  • updated_date (Field2)

Order (주문)

  • od_idx (PK) — Primary key — NOT NULL
  • cu_idx (FK) — Foreign key → Customer.cu_idx — NOT NULL
  • od_status (Field)
  • od_amount (Field2)
  • created_date (Field3)
  • updated_date (Field4)

Order_Detail (주문 항목)

  • odd_idx (PK) — Primary key — NOT NULL
  • mn _idx (PK2) — Foreign key → Menu.mn _idx — NOT NULL
  • od_idx (PK3) — Foreign key → Order.od_idx — NOT NULL
  • cu_idx (FK) — Foreign key → Order.cu_idx — NOT NULL
  • odd_quantity (Field2)
  • odd_price (Field)
  • created_date (Field3)
  • updated_date (Field4)

Payment (결제)

  • pm_idx (PK) — Primary key — NOT NULL
  • od_idx (PK2) — Foreign key → Order.od_idx — NOT NULL
  • cu_idx (FK) — Foreign key → Order.cu_idx — NOT NULL
  • pm_type (Field)
  • pa_amount (Field2)
  • created_date (Field3)
  • update_date (Field4)

System_Admin (관리자)

  • sa_idx (PK) — Primary key — NOT NULL
  • sa_account (Field)
  • sa_password (Field6)
  • sa_name (Field2)
  • sa_email (Field3)
  • created_date (Field4)
  • updated_date (Field5)