회사와 조직

테이블 (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