생카
테이블 (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)