Yankee
Tables (7)
bank (Untitled7)
- account (Field) — not null
- bank (Field2) — not null
- name (Field3) — not null
buy (Untitled6)
- buy_id (Key) — not null — Primary key — NOT NULL
- candle_id (Key2) — not null — Foreign key → candle.candle_id — NOT NULL
- buyer (Field) — not null
- candle_id (Field2) — not null
- candle_title (Field3) — not null
- buy_price (Field4) — not null
- buy_count (Field5) — not null
- candle_image (Field6) — null default
- buy_date (Field7) — not null
- account (Field8) — not null
- deliveryName (Field9) — not null
- deliveryTel (Field10) — not null
- deliveryAddress (Field11) — not null
- sanction (Field12) — null default
candle (Untitled5)
- candle_id (Key) — not null — Primary key — NOT NULL
- candle_kind (Field) — not null
- candle_title (Field2) — not null
- candle_price (Field3) — not null
- candle_count (Field4) — not null
- nation (Field5) — not null
- made_com (Field6) — not null
- made_date (Field7) — not null
- candle_image (Field8) — null default
- candle_cotent (Field9) — not null
- discount_rate (Field10) — null default
- reg_date (Field11) — not null
cart (Untitled4)
- cart_id (Key) — null — Primary key — NOT NULL
- buyer (Field) — not null
- candle_title (Field3) — not null
- buy_price (Field4) — not null
- buy_count (Field5) — not null
- candle_image (Field6) — null default
- candle_id (Key2) — not null — Foreign key → candle.candle_id — NOT NULL
manager (Untitled3)
- managerId (Key) — not null — Primary key — NOT NULL
- managerPasswd (Field) — not null
member (Untitled2)
- id (Key) — pk — Primary key — NOT NULL
- passwd (Field) — not null
- name (Field2) — not null
- reg_date (Field3) — not null
- address (Field4) — not null
- tel (Field5) — not null