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)