멤버십 중심으로 erd 구성
테이블 (32)
attendance_records
- id — BIGINT
- membership_id — BIGINT — NOT NULL
- org_id — BIGINT
- work_date — DATE — NOT NULL
- check_in_at — DATETIME
- check_out_at — DATETIME
- status — VARCHAR(20)
- remarks — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- INDEX — idx_att_org
attendance_summaries
- id — BIGINT
- membership_id — BIGINT — NOT NULL
- org_id — BIGINT
- year_month — VARCHAR(7) — NOT NULL
- days_present — INT
- days_late — INT
- days_absent — INT
- updated_at — DATETIME
- INDEX — idx_attsum_org
audit_logs
- id — BIGINT
- org_id — BIGINT — NOT NULL
- actor_membership_id — BIGINT
- action — VARCHAR(50) — NOT NULL
- entity_type — VARCHAR(50)
- entity_id — BIGINT
- metadata_json — TEXT
- created_at — DATETIME — NOT NULL
- INDEX — idx_audit_org
badge_awards
- id — BIGINT
- badge_id — BIGINT — NOT NULL
- membership_id — BIGINT — NOT NULL
- reason — VARCHAR(255)
- awarded_at — DATETIME — NOT NULL
badges
- id — BIGINT
- org_id — BIGINT — NOT NULL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- INDEX — idx_badge_org
boards
- id — BIGINT
- org_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_anonymous — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_board_org
comments
- id — BIGINT
- post_id — BIGINT — NOT NULL
- author_membership_id — BIGINT — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
contract_actions
- id — BIGINT
- contract_id — BIGINT — NOT NULL
- actor_membership_id — BIGINT — NOT NULL
- action — VARCHAR(20) — NOT NULL
- acted_at — DATETIME — NOT NULL
- ip_hash — VARCHAR(64)
- user_agent — VARCHAR(255)
contract_templates
- id — BIGINT
- org_id — BIGINT — NOT NULL
- name — VARCHAR(120) — NOT NULL
- file_id — BIGINT
- created_at — DATETIME — NOT NULL
contracts
- id — BIGINT
- template_id — BIGINT
- issuer_membership_id — BIGINT — NOT NULL
- target_membership_id — BIGINT — NOT NULL
- org_id — BIGINT
- title — VARCHAR(150)
- status — VARCHAR(20) — NOT NULL
- sent_at — DATETIME
- confirmed_at — DATETIME
- created_at — DATETIME — NOT NULL
- INDEX — idx_ctr_org
departments
- id — BIGINT
- org_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- parent_id — BIGINT
files
- id — BIGINT
- org_id — BIGINT — NOT NULL
- uploader_membership_id — BIGINT — NOT NULL
- storage_key — VARCHAR(255) — NOT NULL
- file_name — VARCHAR(200) — NOT NULL
- mime_type — VARCHAR(100)
- size_bytes — BIGINT
- created_at — DATETIME — NOT NULL
- INDEX — idx_file_org
horoscope_logs
- id — BIGINT
- membership_id — BIGINT — NOT NULL
- on_date — DATE — NOT NULL
- message — VARCHAR(255)
- score — INT
- created_at — DATETIME — NOT NULL
kanban_boards
- id — BIGINT
- org_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_kboard_org
kanban_columns
- id — BIGINT
- board_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- sort_order — INT
leave_approvals
- id — BIGINT
- request_id — BIGINT — NOT NULL
- approver_membership_id — BIGINT — NOT NULL
- org_id — BIGINT
- decision — VARCHAR(20) — NOT NULL
- comment — VARCHAR(255) — ARCHAR(255
- decided_at — DATETIME — NOT NULL
- INDEX — idx_lappr_org
leave_balances
- id — BIGINT
- membership_id — BIGINT — NOT NULL
- policy_id — BIGINT — 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 — DATETIME
leave_policies
- id — BIGINT
- org_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- annual_allowance — DECIMAL(5,1)
- carry_over — DECIMAL(5,1)
- created_at — DATETIME — NOT NULL
- INDEX — idx_policy_org
leave_requests
- id — BIGINT
- membership_id — BIGINT — NOT NULL
- policy_id — BIGINT — NOT NULL
- org_id — BIGINT
- 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 — DATETIME — NOT NULL
- INDEX — idx_lreq_org
notifications
- id — BIGINT
- membership_id — BIGINT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- entity_type — VARCHAR(50)
- entity_id — BIGINT
- payload_json — TEXT
- is_read — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_noti_mem
org_applications
- id — BIGINT
- org_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- dept_id — BIGINT
- requested_role — VARCHAR(16) — NOT NULL
- message — VARCHAR(255)
- status — VARCHAR(16) — NOT NULL
- reviewer_id — BIGINT
- reviewed_at — DATETIME
- reject_reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- INDEX — idx_app_org
- INDEX — idx_app_user
org_invites
- id — BIGINT
- org_id — BIGINT — NOT NULL
- dept_id — BIGINT
- email — VARCHAR(190) — NOT NULL
- role — VARCHAR(16) — NOT NULL
- token — VARCHAR(64) — NOT NULL
- expires_at — DATETIME
- status — VARCHAR(16) — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_inv_org
organizations
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- slug — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
poll_options
- id — BIGINT
- poll_id — BIGINT — NOT NULL
- text — VARCHAR(150) — NOT NULL
poll_votes
- id — BIGINT
- option_id — BIGINT — NOT NULL
- voter_membership_id — BIGINT — NOT NULL
- voted_at — DATETIME — NOT NULL
polls
- id — BIGINT
- post_id — BIGINT — NOT NULL
- question — VARCHAR(200) — NOT NULL
- closes_at — DATETIME
posts
- id — BIGINT
- board_id — BIGINT — NOT NULL
- author_membership_id — BIGINT — NOT NULL
- title — VARCHAR(150)
- content — TEXT
- is_anonymous — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
random_leave_grants
- id — BIGINT
- membership_id — BIGINT — NOT NULL
- policy_id — BIGINT
- days — DECIMAL(5,1)
- campaign_code — VARCHAR(50)
- granted_at — DATETIME — NOT NULL
tasks
- id — BIGINT
- board_id — BIGINT — NOT NULL
- column_id — BIGINT — NOT NULL
- assignee_membership_id — BIGINT
- title — VARCHAR(150) — NOT NULL
- description — TEXT
- priority — VARCHAR(10)
- due_date — DATE
- status — VARCHAR(20)
- created_at — DATETIME — NOT NULL
user_identities
- id — BIGINT
- user_id — BIGINT — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(191) — NOT NULL
- email_at_provider — VARCHAR(190)
- created_at — DATETIME — NOT NULL
- INDEX — idx_identity_user
user_org_memberships
- id — BIGINT
- user_id — BIGINT — NOT NULL
- org_id — BIGINT — NOT NULL
- dept_id — BIGINT
- role — VARCHAR(16) — NOT NULL
- status — VARCHAR(16) — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_mem_user
- INDEX — idx_mem_org
- INDEX — idx_mem_dept
users
- id — BIGINT
- email — VARCHAR(190) — NOT NULL
- name — VARCHAR(80) — NOT NULL
- avatar_url — VARCHAR(255)
- is_active — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL