Dessert Store
Tables (5)
BANNERS (배너)
- ID (Key) — Primary key — NOT NULL
- IMAGE_URL (Field)
- LINK_URL (Field2)
- PRIORITY (Field3)
- IS_ACTIVE (Field4)
- START_DATE (Field5)
- END_DATE (Field6)
ORDERS (주문)
- ID (Key) — Primary key — NOT NULL
- ID (유저 ID) — Foreign key → USERS.ID — NOT NULL
- TOTAL_PRICE (Field2)
- DELIEVERY_ADDRESS (Field3)
- STATUS (Field4)
- ORDER_DATE (Field5)
ORDER_ITEMS (주문상품)
- ID (Key) — Primary key — NOT NULL
- ID (상품 ID) — Foreign key → PRODUCTS.ID — NOT NULL
- ID (Key2) — Foreign key → ORDERS.ID — NOT NULL
- ID (유저 ID) — Foreign key → ORDERS.ID — NOT NULL
- COUNT (Field3)
- ORDER_PRICE (Field4)
PRODUCTS (상품)
- ID (Key) — Primary key — NOT NULL
- PRODUCT_NAME (Field)
- PRICE (Field2)
- CATEGORY (Field3)
- STOCK_COUNT (Field4)
- IMAGE_URL (Field5)
- DESCRIPTION (Field6)
- STATUS (Field7)
USERS (유저정보)
- ID (Key) — Primary key — NOT NULL
- EMAIL (Field)
- PASSWORD (Field2)
- USERNAME (Field3)
- ROLE (Field4)
- STATUS (Field5)
- CREATED_AT (Field6)
- DELETED_AT (Field7)