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