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