SWM-MiniProject

Tables (3)

like (Untitled2)

  • like_id (int) — Integer — Primary key — NOT NULL
  • team_id (int2) — Integer — Foreign key → team.team_id — NOT NULL
  • post_id (int3) — Integer — Foreign key → post.post_id — NOT NULL

post (CopyOfUntitled)

  • post_id (int) — Integer — Primary key — NOT NULL
  • team_id (int2) — Integer — Foreign key → team.team_id — NOT NULL
  • img_url (Field) — Text
  • content (Field2) — Text
  • uploaded_at (Field3) — timestamp

team (Untitled)

  • team_id (int) — Integer — Primary key — NOT NULL
  • team_name (Field5) — Text
  • project_name (text) — Text
  • description (Field) — Text
  • account_id (Field2) — Text
  • account_pw (Field3) — Text
  • profile_url (Field4) — Text