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)