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