멤버십 중심으로 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