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 (Untitled)

  • Field

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