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