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)