최종 프로젝트 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