nsu

Tables (9)

Board (Untitled5)

  • boardId (Key) — Primary key — NOT NULL
  • userId (Field) — String
  • content (Field2) — String
  • picture (Field3)

Comment (Untitled4)

  • Id (Key) — Primary key — NOT NULL
  • boardId (Key2) — Foreign key → Board.boardId — NOT NULL
  • userId (Field) — String
  • content (Field2) — String

Mission (Untitled3)

  • missionId (Key) — Long — Primary key — NOT NULL
  • content (Field2) — String
  • start_date (Field)
  • end_date (Field3)
  • day (Field4)
  • success_count (Field5) — int

Mission (Untitled7)

  • mission_id (missionId) — Long — Primary key — NOT NULL
  • user_id (uid) — Long — Foreign key → User.uid — NOT NULL
  • content — String
  • start_date (startDate) — String
  • end_date (endDate) — String
  • day — List
  • (missionSuccess)

MissionSuccess (Untitled9)

  • success_id — Long — Primary key — NOT NULL
  • mission_id (missionId) — Long — Foreign key → Mission.mission_id — NOT NULL
  • complete — boolean
  • date — String
  • pic
  • review — String

RandomMission (Untitled8)

  • random_mission_Id (mission_id) — Long — Primary key — NOT NULL
  • uid — Long — Foreign key → User.uid — NOT NULL
  • content — String
  • success — boolean
  • date — String
  • pic
  • review — String

Team (Untitled2)

  • team_id (teamId) — Long — Primary key — NOT NULL
  • code (teamCode) — String
  • name (teamName) — String
  • total_point (totalPoint) — int
  • number — int
  • condtion (condition) — String
  • (members)
  • (randomMissions)

TeamRandomMission (Untitled6)

  • random_missionId (mission_id) — Long — Primary key — NOT NULL
  • team_code (teamCode) — Long — Foreign key → Team.team_id — NOT NULL
  • content — String
  • date — String
  • success_count (successCount) — int
  • point — int
  • success_members (successMembers) — List

User (Untitled)

  • uid — Long — Primary key — NOT NULL
  • user_id (userId) — String
  • user_pw (userPw) — String
  • age — int
  • nickname — String
  • role — String
  • gender — String
  • team — Long
  • success_number (successNumber) — int
  • (missions)
  • (randomMissions)