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