sport
Tables (14)
Calender (Untitled11)
- calender_id (Key) — BIGINT — Primary key — NOT NULL — Auto_Increase
- user_id (Key3) — BIGINT — Foreign key → User.user_id — NOT NULL
- match_id (Key4) — BIGINT — Foreign key → Match.match_id — NOT NULL
- event_time (Field) — timestamp
- description (Field2) — VARCHAR(255)
Chat (Untitled8)
- id (Key) — String — Primary key — NOT NULL
- matchId (Field) — Long — match entity
- senderId (Field2) — Long
- message (Field3) — String
- messageType (Field4) — ENUM
- createdTime (Field5) — LocalDateTime — auto
Gender(ENUM) (Untitled6)
- man (Field) — String
- woman (Field2) — String
IsTeamMember (Untitled12)
- SEND (Field) — String
- TEAM (Key) — String — NOT NULL
Match (Untitled3)
- match_id (Key) — BIGINT — Primary key — NOT NULL — Auto_Increase
- sport_type (Field) — ENUM
- location (Field5) — VARCHAR(255)
- player_count (Field3) — INT
- title (Field4) — VARCHAR(255)
- created_time (Field6) — DATETIME(6) — auto
- modified_time (Field7) — DATETIME(6) — auto
MatchState(ENUM) (CopyOfUntitled5)
- WAIT (Field) — String
- COMPLETE (Field2) — String
- CANCELLED (Field3) — String
MessageType(ENUM) (Untitled9)
- JOIN (Field) — String
- TALK (Field2) — String
- LEAVE (Field3) — String
Notification (Untitled10)
- notification _id (Key) — BIGINT — Primary key — NOT NULL — Auto_Increase
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
- notification_content (Field) — VARCHAR(255)
- created_time (Field2) — DATETIME(6) — auto
- modified_time (Field3) — DATETIME(6) — auto
Role(ENUM) (Untitled4)
- ROLE_GUEST (Field) — String
- ROLE_USER (Field2) — String
- ROLE_ADMIN (Field3) — String
SportType(ENUM) (Untitled5)
- soccer (Field) — String
- basketball (Field2) — String
- otherSport (Field3) — String
Team (Untitled2)
- team_id (Key) — BIGINT — Primary key — NOT NULL — Auto_Increase
- team_name (Field) — VARCHAR(255)
- team_count (Field6) — INT
- created_time (Field3) — DATETIME(6) — auto
- modified_time (Field2) — DATETIME(6) — auto
User (Untitled)
- user_id (Key) — BIGINT — Primary key — NOT NULL — Auto_Increase
- email (Field) — VARCHAR(255) — unique=true
- password (Field2) — VARCHAR(255)
- nickname (Field3) — VARCHAR(255)
- gender (Field4) — ENUM
- department (Field5) — VARCHAR(20)
- grade (Field6) — INT
- role (Field7) — ENUM
- created_time (Field8) — DATETIME(6) — auto
- modified_time (Field9) — DATETIME(6) — auto
team_match (Untitled7)
- team_match (Key4) — BIGINT — Primary key — NOT NULL — Auto.Increase
- team_id (Key) — BIGINT — Foreign key → Team.team_id — NOT NULL — 대결 받는 팀
- match_team_id (Key3) — BIGINT — Foreign key → Team.team_id — NOT NULL — 대결 신청 팀
- match_id (Key2) — BIGINT — Foreign key → Match.match_id — NOT NULL
- match_state (Field) — ENUM
- created_time (Field2) — DATETIME(6) — auto
- modified_time (Field3) — DATETIME(6) — auto
- match_date (Field4) — DATETIME
user_team (CopyOfUntitled3)
- user_team_id (Key) — BIGINT — Primary key — NOT NULL — Auto_Increase
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
- team_id (Key3) — BIGINT — Foreign key → Team.team_id — NOT NULL
- is_team_member (Field) — ENUM
- created_time (Field2) — DATETIME(6) — auto
- modified_time (Field3) — DATETIME(6) — auto
- is_pass (Field4) — TINYINT(1)
- is_leave (Field5) — TINYINT(1)