회사와 조직
테이블 (11)
companies (회사정보)
- company_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
- company_code (Field10) — varchar(50)
- company_name (Field) — varchar(100)
- company_type (Field2) — varchar(50)
- business_number (Field3) — varchar(20)
- parent_company_id (Field4) — BIGINT
- is_active (Field5) — boolean
- created_at (Field6) — timestamp
- created_by (Field7) — bigint
- updated_at (Field8) — timestamp
- update_by (Field9) — bigint
company_org_relationships (Untitled2)
- rel_id (Key) — bigserial — 기본 키 — NOT NULL
- company_id (PK) — BIGSERIAL — 외래 키 → companies.company_id — NOT NULL
- org_id (Key2) — bigserial — 외래 키 → org_units.org_id — NOT NULL
- relationship_type (Field3) — varchar(20)
- valid_from (Field4) — timestamp
- valid_until (Field5) — timestamp
- is_active (Field6) — boolean
- remarks (Field7) — text
- created_ay (Field8) — timestamp
group_role_mappings(사용자 그룹-역할 맵핑 테이블) (Untitled7)
- mapping_id (Key) — bigserial — 기본 키 — NOT NULL
- group_id (Key3) — bigserial — 외래 키 → user_groups(사용자 그룹 마스터).group_id — NOT NULL
- role_id (Key2) — bigserial — 외래 키 → roles(역할 마스터 테이블).role_id — NOT NULL
- is_active (Field3) — boolean
- created_at (Field4) — timestamp
- created_by (Field5) — bigint
org_units (Untitled)
- org_id (Key) — bigserial — 기본 키 — NOT NULL
- org_name (Field) — varchar(100)
- org_type (Field11) — varchar(20)
- parent_org_id (Field2) — varchar(20)
- is_active (Field3) — boolean
- path (Field4) — varchar(1000)
- depth (Field5) — integer
- sort_order (Field6) — integer
- created_at (Field7) — timestamp
- created_by (Field8) — bigint
- updated_at (Field9) — timestamp
- update_by (Field10) — bigint
permission_groups(권한 그룹 마스터) (Untitled9)
- perm_group_id (Key) — bigserial — 기본 키 — NOT NULL
- group_name (Field) — varchar(100)
- group_code (Field2) — varchar(50)
- access_type (Field3) — varchar(20)
- main_category (Field4) — varchar(50)
- scope_type (Field5) — varchar(20)
- lock_types (Field6) — varchar()
- danger_levels (Field7) — integer[]
- description (Field8) — text
- is_active (Field9) — boolean
- sort_order (Field10) — integer
- created_at (Field11) — timestamp
- created_by (Field12) — bigint
- updated_at (Field13) — timestamp
- updated_by (Field14) — bigint
permissions(개발권한 테이블) (Untitled8)
- permission_id (Key) — bigserial — 기본 키 — NOT NULL
- permission_code (Field) — varchar(50)
- permission_name (Field2) — varchar(100)
- category (Field3) — varchar(50)
- access_type (Field4) — varchar(20)
- operation_scope (Field5) — varchar(20)
- danger_level (Field6) — integer
- lock_type (Field7) — varchar(20)
- description (Field8) — text
- created_at (Field9) — timestamp
- created_by (Field10) — bigint
- updated_at (Field11) — timestamp
- updated_by (Field12) — bigint
role_permission_group_mappings(역할-권한그룹 맵핑 테이블) (Untitled10)
- mapping_id (Key) — bigserial — 기본 키 — NOT NULL
- role_id (Field) — bigint
- perm_group_id (Field2) — bigint
- is_active (Field3) — boolean
- created_at (Field4) — timestamp
- created_by (Field5) — bigint
- role_id (Key2) — bigserial — 외래 키 → roles(역할 마스터 테이블).role_id — NOT NULL
roles(역할 마스터 테이블) (Untitled6)
- role_id (Key) — bigserial — 기본 키 — NOT NULL
- role_name (Field) — varchar(100)
- role_code (Field2) — varchar(50)
- description (Field3) — text
- role_type (Field4) — varchar(50)
- role_level (Field5) — integer
- is_active (Field6) — boolean
- created_at (Field7) — timestamp
- created_by (Field8) — bigint
user_group_mappings(사용자-사용자 그룹 맵핑) (Untitled4)
- mapping_id (Key) — bigserial — 기본 키 — NOT NULL
- user_id (Key4) — bigserial — 외래 키 → users (사용자 기본정보 테이블).user_id — NOT NULL
- group_id (Key2) — bigserial — 외래 키 → user_groups(사용자 그룹 마스터).group_id — NOT NULL
- role_type (Field3) — varchar(30)
- status (Field4) — varchar(20)
- valid_from (Field5) — timestamp
- valid_util (Field6) — timestamp
- created_at (Field7) — timestamp
- created_by (Field8) — bigint
- updated_at (Field9) — timestamp
- updated_by (Field10) — bigint
user_groups(사용자 그룹 마스터) (Untitled3)
- group_id (Key) — bigserial — 기본 키 — NOT NULL
- parent_group_id (Field) — bigint
- group_code (Field2) — varchar(50)
- group_name (Field3) — varchar(100)
- group_level (Field4) — integer
- group_type (Field5) — varchar(30)
- organization_path (Field14) — text
- description (Field6) — text
- department_id (Field7) — varchar(50)
- is_active (Field8) — boolean
- sort_order (Field9) — integer
- valid_from (Field15) — timestamp
- valid_until (Field16) — timestamp
- created_at (Field10) — timestamp
- created_by (Field11) — bigint
- updated_at (Field12) — timestamp
- updated_by (Field13) — bigint
users (사용자 기본정보 테이블) (Untitled5)
- user_id (Key) — bigserial — 기본 키 — NOT NULL
- company_id (PK) — BIGSERIAL — 외래 키 → companies.company_id — NOT NULL
- dept_id (Field2) — bigint
- user_type (Field3) — varchar(20)
- user_name_first (Field4) — varchar(50)
- user_name_last (Field5) — varchar(50)
- user_name_full (Field6) — varchar(100)
- employee_nymber (Field7) — varchar(20)
- position (Field8) — varchar(50)
- duty (Field9) — varchar(50)
- mobile_phone (Field10) — varchar(20)
- email (Field11) — varchar(100)
- login_id (Field12) — varchar(50)
- login_method (Field13) — varchar(20)
- password_hash (Field14) — varchar(255)
- force_pw_reset (Field15) — boolean
- first_login_required (Field16) — boolean
- account_locked (Field17) — boolean
- login_fail_count (Field18) — int
- max_login_fail_count (Field19) — int
- offline_pin_enabled (Field20) — boolean
- emp_status (Field21) — varchar(20)
- status (Field22) — varchar(10)
- created_at (Field23) — timestamp
- created_by (Field24) — bigint
- updated_at (Field25) — timestamp
- updated_by (Field26) — bigint