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)