CMS

Tables (9)

content

  • id — BIGSERIAL
  • menu_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_by — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

department

  • id — BIGSERIAL
  • organization_id — BIGINT — NOT NULL
  • parent_dept_id — BIGINT
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • dept_type — VARCHAR(20) — NOT NULL
  • depth — INT — NOT NULL
  • path — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

membership_permission

  • id — BIGSERIAL
  • membership_id — BIGINT — NOT NULL
  • permission_code_id — BIGINT — NOT NULL
  • granted_at — TIMESTAMPTZ — NOT NULL
  • granted_by — BIGINT

menu

  • id — BIGSERIAL
  • organization_id — BIGINT — NOT NULL
  • parent_menu_id — BIGINT
  • code — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • url — VARCHAR(200)
  • sort_order — INT — NOT NULL
  • depth — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

menu_access_rule

  • id — BIGSERIAL
  • menu_id — BIGINT — NOT NULL
  • department_id — BIGINT
  • required_permission_id — BIGINT — NOT NULL
  • dept_scope_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

organization

  • id — BIGSERIAL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

permission_code

  • id — BIGSERIAL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • category — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user

  • id — BIGSERIAL
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(200)
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_membership

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • organization_id — BIGINT — NOT NULL
  • department_id — BIGINT — NOT NULL
  • title — VARCHAR(100)
  • scope_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL