생카

테이블 (11)

ACTIVITY (TABLE10)

  • activity_id — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(100)
  • type — VARCHAR(50)
  • start_date — DATE
  • end_date — DATE
  • event_id — INTEGER — 외래 키 → EVENT.event_id

ACTIVITY_PRIZE (TABLE11)

  • prize_id — INTEGER — 기본 키 — NOT NULL
  • activity_id — INTEGER — 외래 키 → ACTIVITY.activity_id
  • item_id (merch_id) — INTEGER — 외래 키 → ITEM.item_id
  • name — VARCHAR(100)
  • quantity — INTEGER

EVENT (TABLE)

  • event_id — INTEGER — 기본 키 — NOT NULL
  • place_id (cafe_id) — INTEGER — 외래 키 → PLACE.place_id
  • name — VARCHAR(100)
  • theme — VARCHAR(100)
  • description — TEXT
  • start_date — DATE
  • end_date — DATE
  • budget_total — INTEGER

ITEM (TABLE3)

  • item_id (merch_id) — INTEGER — 기본 키 — NOT NULL
  • event_id — INTEGER — 외래 키 → EVENT.event_id
  • name — VARCHAR(100)
  • category — VARCHAR(50)
  • price (Field) — INTEGER
  • order_quantity (Field2) — INTEGER
  • order_count (Field3) — INTEGER
  • order_note (Field4) — text
  • vendor_id — INTEGER — 외래 키 → VENDOR.vendor_id — NOT NULL

LUCKYDRAW (Untitled3)

  • lucky_id (Key) — INTEGER — 기본 키 — NOT NULL
  • event_id — INTEGER — 외래 키 → EVENT.event_id — NOT NULL
  • draw_price (Field) — INTEGER
  • draw_count (Field2) — INTEGER
  • max_draw_count (Field3) — INTEGER

LUCKYDRAW_PRIZE (Untitled4)

  • item_id (merch_id) — INTEGER — 외래 키 → ITEM.item_id — NOT NULL
  • lucky_id (Key) — INTEGER — 외래 키 → LUCKYDRAW.lucky_id — NOT NULL
  • quantity (Field)

PLACE (TABLE2)

  • place_id (cafe_id) — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(100)
  • address — VARCHAR(200)
  • contact — VARCHAR(20)
  • capacity — INTEGER

STAFF (TABLE6)

  • staff_id — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(50)
  • role — VARCHAR(50)
  • contact — VARCHAR(50)

STAFF_TASK (TABLE12)

  • task_id — INTEGER — 외래 키 → TASK.task_id — NOT NULL
  • staff_id — INTEGER — 외래 키 → STAFF.staff_id — NOT NULL

TASK (TABLE7)

  • task_id — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(100)
  • due_date — DATE
  • event_id — INTEGER — 외래 키 → EVENT.event_id

VENDOR (TABLE4)

  • vendor_id — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(100)
  • address — VARCHAR(200)
  • contact — VARCHAR(20)
  • type — VARCHAR(50)