최종 프로젝트 ERD

테이블 (32)

attendance_records

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • work_date — DATE — NOT NULL
  • check_in_at — TIMESTAMP
  • check_out_at — TIMESTAMP
  • status — VARCHAR(20)
  • remarks — VARCHAR(255)
  • created_at — TIMESTAMP

attendance_summaries

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • year_month — VARCHAR(7) — NOT NULL
  • days_present — INT
  • days_late — INT
  • days_absent — INT
  • updated_at — TIMESTAMP

audit_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • actor_user_id — BIGINT — 외래 키 → users.id
  • action — VARCHAR(50) — NOT NULL
  • entity_type — VARCHAR(50)
  • entity_id — BIGINT
  • metadata_json — TEXT
  • created_at — TIMESTAMP

badge_awards

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • badge_id — BIGINT — 외래 키 → badges.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • reason — VARCHAR(255)
  • awarded_at — TIMESTAMP

badges

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • created_at — TIMESTAMP

boards

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_anonymous — SMALLINT
  • created_at — TIMESTAMP

comments

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • post_id — BIGINT — 외래 키 → posts.id — NOT NULL
  • author_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP

contract_actions

  • id — BIGINT — 기본 키 — NOT NULL
  • contract_id — BIGINT — 외래 키 → contracts.id — NOT NULL
  • actor_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • acted_at — TIMESTAMP
  • ip_hash — VARCHAR(64)
  • user_agent — VARCHAR(255)

contract_templates

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • file_id — BIGINT
  • created_at — TIMESTAMP

contracts

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • template_id — BIGINT — 외래 키 → contract_templates.id
  • title — VARCHAR(150)
  • file_id — BIGINT
  • issuer_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • target_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • sent_at — TIMESTAMP
  • confirmed_at — TIMESTAMP
  • created_at — TIMESTAMP

departments

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • parent_id — BIGINT — 외래 키 → departments.id
  • created_at — TIMESTAMP

files

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • uploader_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • storage_key — VARCHAR(255) — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • mime_type — VARCHAR(100)
  • size_bytes — BIGINT
  • created_at — TIMESTAMP

horoscope_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • on_date — DATE — NOT NULL
  • message — VARCHAR(255)
  • score — INT
  • created_at — TIMESTAMP

kanban_boards

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP

kanban_columns

  • id — BIGINT — 기본 키 — NOT NULL
  • board_id — BIGINT — 외래 키 → kanban_boards.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • sort_order — INT

leave_approvals

  • id — BIGINT — 기본 키 — NOT NULL
  • request_id — BIGINT — 외래 키 → leave_requests.id — NOT NULL
  • approver_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • decision — VARCHAR(20) — NOT NULL
  • comment — VARCHAR(255) — ARCHAR(255
  • decided_at — TIMESTAMP

leave_balances

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • policy_id — BIGINT — 외래 키 → leave_policies.id — NOT NULL
  • year — INT — NOT NULL
  • entitled — DECIMAL(5,1)
  • used — DECIMAL(5,1)
  • pending_hold — DECIMAL(5,1)
  • remaining — DECIMAL(5,1)
  • updated_at — TIMESTAMP

leave_policies

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • annual_allowance — INT
  • carry_over — INT
  • created_at — TIMESTAMP

leave_requests

  • id — BIGINT — 기본 키 — NOT NULL
  • policy_id — BIGINT — 외래 키 → leave_policies.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • days — DECIMAL(5,1) — NOT NULL
  • reason — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP

notifications

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • entity_type — VARCHAR(50)
  • entity_id — BIGINT
  • payload_json — TEXT
  • is_read — SMALLINT
  • created_at — TIMESTAMP

org_applications

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • dept_id — BIGINT — 외래 키 → departments.id
  • requested_role — VARCHAR(10) — NOT NULL
  • message — VARCHAR(255)
  • status — VARCHAR(10) — NOT NULL
  • reviewer_id — BIGINT — 외래 키 → users.id
  • reviewed_at — TIMESTAMP
  • reject_reason — VARCHAR(255)
  • created_at — TIMESTAMP

org_invites

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • dept_id — BIGINT — 외래 키 → departments.id
  • email — VARCHAR(190) — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • token — VARCHAR(64) — NOT NULL
  • expires_at — TIMESTAMP
  • status — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP

organizations

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

poll_options

  • id — BIGINT — 기본 키 — NOT NULL
  • poll_id — BIGINT — 외래 키 → polls.id — NOT NULL
  • text — VARCHAR(150) — NOT NULL

poll_votes

  • id — BIGINT — 기본 키 — NOT NULL
  • option_id — BIGINT — 외래 키 → poll_options.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • voted_at — TIMESTAMP

polls

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • post_id — BIGINT — 외래 키 → posts.id — NOT NULL
  • question — VARCHAR(200) — NOT NULL
  • closes_at — TIMESTAMP

posts

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • board_id — BIGINT — 외래 키 → boards.id — NOT NULL
  • author_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(150)
  • content — TEXT
  • is_anonymous — SMALLINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

random_leave_grants

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • policy_id — BIGINT — 외래 키 → leave_policies.id
  • days — DECIMAL(5,1)
  • campaign_code — VARCHAR(50)
  • granted_at — TIMESTAMP

tasks

  • id — BIGINT — 기본 키 — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • board_id — BIGINT — 외래 키 → kanban_boards.id — NOT NULL
  • column_id — BIGINT — 외래 키 → kanban_columns.id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • description — TEXT
  • assignee_user_id — BIGINT — 외래 키 → users.id
  • priority — VARCHAR(10)
  • due_date — DATE
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

user_identities

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(191) — NOT NULL
  • email_at_provider — VARCHAR(190)
  • created_at — TIMESTAMP

user_org_memberships

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • org_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • dept_id — BIGINT — 외래 키 → departments.id
  • role — VARCHAR(10) — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • created_at — TIMESTAMP

users

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(190) — NOT NULL
  • name — VARCHAR(80) — NOT NULL
  • avatar_url — VARCHAR(255)
  • is_active — SMALLINT
  • created_at — TIMESTAMP