artistry
Tables (8)
Application (application)
- id (Key) — Primary key — NOT NULL
- TeamRole (Key2) — Primary key — NOT NULL
- Portfolio (Key3) — Primary key — NOT NULL
- status (Field)
- type (Field2)
Content (content)
- id (Key) — Primary key — NOT NULL
- Url (Field)
- Comment (Field2)
- id (Key2) — Foreign key → Portfolio.id — NOT NULL
- Member (Key22) — Foreign key → Portfolio.Member — NOT NULL
- Role (Key3) — Foreign key → Portfolio.Role — NOT NULL
- Contents (Key4) — Foreign key → Portfolio.Contents — NOT NULL
- id (Key42) — Foreign key → Portfolio.id — NOT NULL
- host_id (Key222) — Foreign key → Portfolio.host_id — NOT NULL
- TeamRoles (Key322) — Foreign key → Portfolio.TeamRoles — NOT NULL
- Tags (Key422) — Foreign key → Portfolio.Tags — NOT NULL
Member (member)
- id (Key) — Primary key — NOT NULL
- Portfolios (Key2) — Primary key — NOT NULL
- hostTeams (Key3) — Primary key — NOT NULL
- id (Key4) — Foreign key → Team.id — NOT NULL
- host_id (Key22) — Foreign key → Team.host_id — NOT NULL
- TeamRoles (Key32) — Foreign key → Team.TeamRoles — NOT NULL
- Tags (Key42) — Foreign key → Team.Tags — NOT NULL
- Nickname (Field)
- Email (Field2)
- url (Field3)
- Bio (Field4)
- MemberLinks (Field5)
- Field6
Portfolio (portfolio)
- id (Key) — Primary key — NOT NULL
- Member (Key2) — Primary key — NOT NULL
- Role (Key3) — Primary key — NOT NULL
- Contents (Key4) — Primary key — NOT NULL
- Title (Field)
- View (Field2)
- Like (Field3)
- access (Field4) — Enum
- id (Key5) — Foreign key → Application.id — NOT NULL
- TeamRole (Key22) — Foreign key → Application.TeamRole — NOT NULL
- Portfolio (Key32) — Foreign key → Application.Portfolio — NOT NULL
- id (Key6) — Foreign key → Member.id — NOT NULL
- Portfolios (Key23) — Foreign key → Member.Portfolios — NOT NULL
- hostTeams (Key33) — Foreign key → Member.hostTeams — NOT NULL
- id (Key42) — Foreign key → Member.id — NOT NULL
- host_id (Key222) — Foreign key → Member.host_id — NOT NULL
- TeamRoles (Key322) — Foreign key → Member.TeamRoles — NOT NULL
- Tags (Key422) — Foreign key → Member.Tags — NOT NULL
Role (role)
- id (Key) — Primary key — NOT NULL
- TeamRoles (Key2) — Primary key — NOT NULL
- name (Field)
Tag (tag)
- id (Key) — Primary key — NOT NULL
- name (Field)
Team (team)
- id (Key) — Primary key — NOT NULL
- host_id (Key2) — Primary key — NOT NULL
- TeamRoles (Key3) — Primary key — NOT NULL
- Tags (Key4) — Primary key — NOT NULL
- id (Field)
- name (field)
- teamStatus (Field2)
- created_at (Field3)
- id (Key5) — Foreign key → Tag.id — NOT NULL
TeamRole (teamRole)
- id (Key) — Primary key — NOT NULL
- Team_id (Key2) — Primary key — NOT NULL
- Role_id (Key3) — Primary key — NOT NULL
- Applications (Key5) — Primary key — NOT NULL
- id (Key4) — Foreign key → Team.id — NOT NULL
- host_id (Key22) — Foreign key → Team.host_id — NOT NULL
- TeamRoles (Key32) — Foreign key → Team.TeamRoles — NOT NULL
- Tags (Key42) — Foreign key → Team.Tags — NOT NULL
- id (Key6) — Foreign key → Role.id — NOT NULL
- TeamRoles (Key23) — Foreign key → Role.TeamRoles — NOT NULL
- id (Key7) — Foreign key → Application.id — NOT NULL
- TeamRole (Key24) — Foreign key → Application.TeamRole — NOT NULL
- Portfolio (Key33) — Foreign key → Application.Portfolio — NOT NULL