V3

Tables (7)

FeaturingAccount (통합 회원)

  • pk (id) — integer — Primary key — NOT NULL
  • Field (email) — char
  • Field (password) — char
  • Field (nickname) — char
  • Field (phone) — char
  • Field (position) — char
  • Field (fullname) — char
  • Field (profile_image) — image
  • Field (business_name) — ....
  • Field (business_size) — integer
  • Field (business_number) — char
  • Field (homepage) — char
  • Field (tel) — char
  • Field (is_verify_phone) — bool
  • Field (is_staff) — bool
  • Field (date_joined) — datetime
  • Field (is_bot_mode) — bool
  • Field (is_test_mode) — bool
  • Field (deleted_at) — datetime
  • Field (blocked_at) — datetime
  • Field (blocked_reason) — char

OrganazationAccountPermission (오그 계정 퍼미션)

  • pk (id) — integer — Primary key — NOT NULL
  • fk (organizaionaccount_id) — integer — Foreign key → OrganizationAccount.pk — NOT NULL
  • Field (name) — char

OrganazationPermission (오그 퍼미션)

  • pk (id) — integer — Primary key — NOT NULL
  • fk (organization_id) — integer — Foreign key → Organization.pk — NOT NULL
  • Field (name) — char

Organization (오그)

  • pk (id) — integer — Primary key — NOT NULL
  • fk (created_by) — integer — Foreign key → FeaturingAccount.pk — NOT NULL
  • Field (code) — char
  • Field (name) — char
  • Field (description) — char
  • Field (is_active) — bool
  • Field (sub_domain) — char
  • Field (deleted_at) — datetime

OrganizationAccount (테넌트 계정)

  • pk (id) — integer — Primary key — NOT NULL
  • fk (featuring_account_id) — integer — Foreign key → FeaturingAccount.pk — NOT NULL
  • fk (organization_id) — integer — Foreign key → Organization.pk — NOT NULL
  • Field (created_at) — char
  • Field (code) — char

Project (프로젝트)

  • pk (id) — integer — Primary key — NOT NULL
  • fk (organization_id) — integer — Foreign key → Organization.pk — NOT NULL
  • fk (organization_account_id) — integer — Foreign key → OrganizationAccount.pk — NOT NULL
  • Field (code) — char
  • Field (name) — char
  • Field (description) — char
  • Field (is_active) — bool
  • Field (deleted_at) — datetime

ProjectMember (프로젝트 멤버)

  • pk (id) — integer — Primary key — NOT NULL
  • fk (project_id) — integer — Foreign key → Project.pk — NOT NULL
  • pk (organization_account_id) — integer — Foreign key → OrganizationAccount.pk — NOT NULL
  • pk (id2) — integer — Foreign key → Project.fk — NOT NULL