cmax
Tables (7)
Untitled2
- Key — Primary key — NOT NULL
- Field
- Field2
- Field3
Untitled3
- Key — Primary key — NOT NULL
- Field
- Field2
- Field3
authority
- id — uuid — Primary key — NOT NULL
- name — text — NOT NULL
- level — bigint — NOT NULL
- description — text
- parent_id — uuid
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
menu
- id — uuid — Primary key — NOT NULL
- name — text
- parent_id — uuid
- type — text
- url — text
- icon — text
- permission — text
- code — text
- parent_code — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
menu_authority
- id — uuid — Primary key — NOT NULL
- menu_id — uuid — Foreign key → menu.id — NOT NULL
- authority_id — uuid — Foreign key → authority.id — NOT NULL
- created_at — timestamp — NOT NULL
- created_id — uuid
- updated_id — uuid
- updated_at — timestamp
profiles (Untitled)
- 프로필id (id) — uuid — Primary key — NOT NULL
- 이름 (name) — text
- 휴대폰번호 (phone_number) — text
- 주소 (address) — text
- 생성자 (created_id) — uuid
- 수정자 (updated_id) — uuid
- 생성일 (created_at) — timestamptz
- 수정일 (updated_at) — timestamptz
- 대표이름 (display_name) — text
- 프로필이미지 (avata_url) — text
profiles_authority
- id — uuid — Primary key — NOT NULL
- 프로필id (profiles_id) — uuid — Foreign key → profiles.프로필id — NOT NULL
- authority_id — uuid — Foreign key → authority.id — NOT NULL
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp