key-pick
테이블 (10)
Untitled (branch)
- Key (branch_id) — INTEGER — 기본 키 — NOT NULL
- Field (branch_name) — VARCHAR(100) — NOT NULL
- Field2 (location) — TEXT — NOT NULL
- Field (phone) — VARCHAR(20) — NOT NULL
- Field (is_active) — BOOLEAN — NOT NULL
Untitled (branch_assignment)
- Key (assignment_id) — INTEGER — 기본 키 — NOT NULL
- Key (branch_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- member_id — INTEGER — 외래 키 → 회원.member_id — NOT NULL
- Field (assigned_at) — DATETIME — NOT NULL
Untitled (reservation)
- Key (reservation_id) — INTEGER — 기본 키 — NOT NULL
- member_id — INTEGER — 외래 키 → 회원.member_id
- Key (theme_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- Field (reservation_time) — DATETIME — NOT NULL
- Field (num_of_participants) — INTEGER — NOT NULL
- Field (total_price) — DECIMAL — NOT NULL
- Field (status) — VARCHAR(20) — NOT NULL
- Field (hint_count) — INTEGER — NOT NULL
- Field (is_success) — BOOLEAN — NOT NULL
Untitled (payment)
- Key (payment_id) — INTEGER — 기본 키 — NOT NULL
- Key (reservation_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- Field2 (payment_method) — VARCHAR(50) — NOT NULL
- Field2 (amount) — DECIMAL — NOT NULL
- Field2 (payment_status) — VARCHAR(20) — NOT NULL
- Field2 (paid_at) — DATETIME — NOT NULL
Untitled (review)
- Key (review_id) — INTEGER — 기본 키 — NOT NULL
- Key (reservation_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- member_id — INTEGER — 외래 키 → 회원.member_id — NOT NULL
- Field (rating) — INTEGER — NOT NULL
- Field (comment) — TEXT — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
Untitled (schedule)
- Key (schedule_id) — INTEGER — 기본 키 — NOT NULL
- member_id — INTEGER — 외래 키 → 회원.member_id — NOT NULL
- Key (branch_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- Key (assigned_theme_id) — INTEGER — 외래 키 → Untitled.Key
- Field (work_date) — DATE — NOT NULL
- Field (start_time) — TIME — NOT NULL
- Field (end_time) — TIME — NOT NULL
Untitled (notice)
- Key (notice_id) — INTEGER — 기본 키 — NOT NULL
- member_id — INTEGER — 외래 키 → 회원.member_id — NOT NULL
- Key (target_branch_id) — INTEGER — 외래 키 → Untitled.Key
- Field (title) — VARCHAR(255) — NOT NULL
- Field (content) — TEXT — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
Untitled (theme)
- Key (theme_id) — INTEGER — 기본 키 — NOT NULL
- Key (branch_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field (genre) — VARCHAR(50) — NOT NULL
- Field (difficulty) — INTEGER — NOT NULL
- Field (price) — DECIMAL — NOT NULL
- Field (discount_rate) — DECIMAL — NOT NULL
- Field (status) — VARCHAR(20) — NOT NULL
Untitled (issue_report)
- Key (report_id) — INTEGER — 기본 키 — NOT NULL
- Key (theme_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- member_id (reported_by_member_id) — INTEGER — 외래 키 → 회원.member_id — NOT NULL
- Field (issue_description) — TEXT — NOT NULL
- Field (status) — VARCHAR(20) — NOT NULL
- Field (reported_at) — DATETIME — NOT NULL
회원 (member)
- member_id — INTEGER — 기본 키 — NOT NULL
- Field (login_id) — VARCHAR(100) — NOT NULL
- Field (password) — VARCHAR(128) — NOT NULL
- Field (name) — VARCHAR(50) — NOT NULL
- Field (phone) — VARCHAR(20) — NOT NULL
- Field (role) — VARCHAR(20) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL