tukweb

Tables (4)

Member (Untitled)

  • member_id (Key) — Primary key — NOT NULL
  • name (Field)
  • login_id (Field2)
  • password (Field3)
  • email (Field4)
  • role (Field5)

Team (Untitled2)

  • team_id (Key) — Primary key — NOT NULL
  • name (Field)
  • team_capacity (Field2)
  • due_date (Field3)
  • content (Field4)
  • field (Field5)

Team_Member (Untitled4)

  • team_member_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL
  • team_id (Key3) — Foreign key → Team.team_id — NOT NULL
  • application_status (Field)

coment (Untitled3)

  • coment_id (Key) — Primary key — NOT NULL
  • content (Field)
  • created_at (Field2)
  • team_id (Key2) — Foreign key → Team.team_id — NOT NULL
  • team_member_id (Key3) — Foreign key → Team_Member.team_member_id — NOT NULL