tingle

Tables (8)

Photo (Untitled2)

  • Key (Photo_id) — int — Primary key — NOT NULL
  • PK (User_id) — varchar — Foreign key → User.PK — NOT NULL

Team_info (Untitled4)

  • Key (Team_id) — int — Primary key — NOT NULL
  • PK (User_id) — varchar — Foreign key → User.PK — NOT NULL
  • Field (birth) — int
  • Field (gender) — varchar
  • Field (department) — varchar

Team_list (Untitled3)

  • Key (Team_id) — int — Primary key — NOT NULL
  • Field
  • Key (Team_id2) — int — Foreign key → Team_info.Key — NOT NULL
  • PK (User_id) — varchar — Foreign key → Team_info.PK — NOT NULL

User (Untitled)

  • PK (User_id) — varchar — Primary key — NOT NULL
  • Field (password) — varchar
  • Field (name) — varchar
  • Field (birth) — int
  • Field (gender) — varchar
  • Field (nickname) — varchar
  • Field (school_number) — int
  • Field (department) — varchar

mission (Untitled7)

  • Key (User_id) — varchar — Primary key — NOT NULL
  • PK (User_id2) — varchar — Foreign key → User.PK — NOT NULL
  • Field

recommendation (Untitled8)

  • Key (User_id) — varchar — Primary key — NOT NULL
  • PK (User_id2) — varchar — Foreign key → User.PK — NOT NULL
  • Field

report (Untitled5)

  • Key (User_id) — varchar — Primary key — NOT NULL
  • PK (User_id2) — varchar — Foreign key → User.PK — NOT NULL

review (Untitled6)

  • Key (User__id) — varchar — Primary key — NOT NULL
  • PK (User_id) — varchar — Foreign key → User.PK — NOT NULL
  • Field