wooriTeam

Tables (3)

Untitled (woori_team_teams)

  • Key (team_id) — integer — Primary key — NOT NULL
  • Key (user_id) — integer — Foreign key → woori_team_users.Key — NOT NULL
  • Field (team_title) — varchar(20)
  • Field (team_comment) — varchar(20)
  • Field (current_personnel) — varchar(20) — NOT NULL
  • Field (want_personnel) — varchar(20) — NOT NULL
  • Field (create_date) — timestamp — NOT NULL

Untitled (woori_technics)

  • Key (technic_id) — integer — Primary key — NOT NULL
  • Key (team_id) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (technic_name) — varchar(20) — NOT NULL

woori_team_users

  • Key (user_id) — integer — Primary key — NOT NULL
  • Field (account_id) — text
  • Field (username) — varchar(20)