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