sports_community

Tables (20)

Calender (캘린더)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • date (Field) — Date
  • title (Field2) — string
  • description (Field3) — string
  • color (Field4) — string

Club (동아리)

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — string
  • region (Field4) — enum
  • members (Field6) — number
  • description (Field9) — string
  • master (Field10) — number
  • score (Field2) — number
  • createdAt (Field7) — Date
  • updatedAt (Field8) — Date

Club _aplication (클럽신청)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • club_id (Key3) — number — Foreign key → Club.id — NOT NULL
  • message (신청글) — string
  • status (Field) — enum

Club_form (동아리 대결 신청)

  • id (Key) — number — Primary key — NOT NULL
  • club_id (Key2) — number — Foreign key → Posts.id — NOT NULL
  • post_id (Key3) — number — Foreign key → Club.id — NOT NULL
  • content (Field) — string
  • status (Field2) — enum

Club_score (클럽평가지)

  • id (Key) — number — Primary key — NOT NULL
  • club_id (Key2) — number — Foreign key → Club.id — NOT NULL
  • personality (Field) — number
  • ability (Field2) — number
  • count (Field4) — number

Club_tag (동아리 평가 태그)

  • id (Key) — number — Primary key — NOT NULL
  • club_tag_count_id (Key2) — number — Foreign key → Club_tag_count.id — NOT NULL
  • buksan (북산) — boolean
  • sanantonio (센안토니오) — boolean
  • gentle (젠틀) — boolean
  • manner (매너) — boolean
  • lakers (레이커스) — boolean
  • oneman (원맨팀) — boolean
  • goldenstate (골스) — boolean
  • notbed (낫배드) — boolean
  • bed (배드가이즈) — boolean
  • tough (터프가이즈) — boolean
  • fighter (파이터즈) — boolean
  • late (지각) — boolean
  • zaza (파출리아가이즈) — boolean

Club_tag_count (동아리 태그 수)

  • id (Key) — number — Primary key — NOT NULL
  • club_id (Key2) — number — Foreign key → Club.id — NOT NULL
  • buksan (북산) — number
  • sanantonio (센안토니오) — number
  • gentle (젠틀) — number
  • manner (매너) — number
  • lakers (레이커스) — number
  • oneman (원맨팀) — number
  • goldenstate (골스) — number
  • notbed (낫배드) — number
  • bed (배드가이즈) — number
  • tough (터프가이즈) — number
  • fighter (파이터즈) — number
  • late (지각) — number
  • zaza (파출리아가이즈) — number

Participants (사용자&채팅 참가)

  • id (Key) — number — Primary key — NOT NULL
  • creator_id (Key4) — number — Foreign key → users.id — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • chat_id (Key3) — number — Foreign key → chat.id — NOT NULL
  • createdAt (Field2) — Date
  • deletedAt (Field) — Date

Personal_form (개인 대결 신청)

  • id (Key) — number — Primary key — NOT NULL
  • post_id (Key2) — number — Foreign key → Posts.id — NOT NULL
  • user_id (Key3) — number — Foreign key → users.id — NOT NULL
  • content (Field) — string
  • status (Field2) — enum

Position (선호포지션)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • guard (Field) — boolean
  • center (Field2) — boolean
  • forward (Field3) — boolean

Posts (게시글)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • title (Field) — string
  • region (Field2) — enum
  • gps (Field8) — string
  • content (Field3) — string
  • image (Field4) — string
  • gamedate (Field11) — Date
  • runtime (Field10) — number
  • rule (Field7) — enum
  • group (Field13) — boolean
  • total (Field9) — number
  • status (Field12) — enum
  • createdAt (Field5) — Date
  • updatedAt (Field6) — Date

User_score (유저 평가지)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • rater_id (Key3) — number — Foreign key → users.id — NOT NULL
  • personality (Field) — number
  • ability (Field2) — number
  • mvp (Field3) — number
  • count (Field4) — number

User_tag (유저 평가 태그)

  • id (Key) — number — Primary key — NOT NULL
  • tag_id (Key3) — number — Foreign key → User_tag_count.id — NOT NULL
  • jorden (조던) — boolean
  • daeman (정대만) — boolean
  • beakho (강백호) — boolean
  • teawoong (서태웅) — boolean
  • chisu (채치수) — boolean
  • curry (커리) — boolean
  • irving (어빙) — boolean
  • yakbird (으악새) — boolean
  • late (지각) — boolean
  • run (도망감) — boolean
  • thief (도둑) — boolean
  • mean (예민함) — boolean
  • zaza (파출리아) — boolean

User_tag_count (유저 태그 수)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • jorden (조던) — number
  • daeman (정대만) — number
  • beakho (강백호) — number
  • teawoong (서태웅) — number
  • chisu (채치수) — number
  • curry (커리) — number
  • irving (어빙) — number
  • yakbird (으악새) — number
  • late (지각) — number
  • run (도망감) — number
  • thief (도둑) — number
  • mean (예민함) — number
  • zaza (파출리아) — number

alarm (알림)

  • Key — Primary key — NOT NULL
  • uesr_id (Key2) — number — Foreign key → users.id — NOT NULL
  • message (Field) — string
  • read (Field2) — boolean

chat (채팅방)

  • id (Key) — number — Primary key — NOT NULL
  • title (Field2) — string
  • createdAt (Field) — Date
  • deletedAt (Field3) — Date

messages (채팅 메세지)

  • Key — Primary key — NOT NULL
  • chat_id (Key2) — number — Foreign key → chat.id — NOT NULL
  • user_id (Key3) — number — Foreign key → users.id — NOT NULL
  • content (Field) — string
  • createdAt (Field2) — Date

profiles (프로필정보)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • nickname (Field) — string
  • gender (Field8) — enum
  • description (Field2) — string
  • image (Field9) — string
  • height (Field4) — number
  • createdAt (Field5) — Date
  • updatedAt (Field7) — Date

user_club (사용자&클럽)

  • id (Key) — number — Primary key — NOT NULL
  • user_id (Key2) — number — Foreign key → users.id — NOT NULL
  • club_id (Key3) — number — Foreign key → Club.id — NOT NULL

users (사용자)

  • id (Key) — number — Primary key — NOT NULL
  • email (Field) — string
  • password (Field2) — string
  • name (Field3) — string
  • currentRefreshToken (Field4) — string
  • createdAt (Field5) — Date
  • updatedAt (Field6) — Date
  • deletedAt (Field7) — Date