GoodMinton
Tables (15)
ChildComment (대댓글)
- childComment_id (PK) — Long — Primary key — NOT NULL
- comment_id (FK) — Long — Foreign key → Comment.comment_id — NOT NULL
- content (Field) — String
- reported (Field2) — Boolean
Comment (댓글)
- comment_id (PK) — Long — Primary key — NOT NULL
- post_id (FK) — Long — Foreign key → Post.post_id — NOT NULL
- content (Field) — String
- user_id (Field3) — Long
- reported (Field4) — boolean
Member (멤버)
- memner_id (PK) — Long — Primary key
- email (Field4) — String
- pw (Field) — String
- nickname (Field2) — String
- social (Field3) — boolean
- birthdate (Field6) — Date
- gender (Field7)
- location_city (시, 군) — String
- location_one (구, 읍, 면)
- location_two (동, 리)
- phone_number (Field5)
- access_divice (접속한 기기)
- profile_image (프로필 이미지)
- active_days (운동 가능 요일)
- is_noti_channel_eamil (Field8) — boolean
- is_noti_channel_message (Field9) — boolean
- is_noti_channel_app (Field10) — boolean
- is_functionality_community (Field11) — boolean
- is_functionality_opposite (Field12) — boolean
- is_functionality_competiton (Field13) — boolean
Member_active_hours (사용자 운동 가능 시간)
- member_active_hours_id (PK) — Primary key — NOT NULL
- member_id (FK) — Primary key — NOT NULL
- memner_id (PK2) — Long — Foreign key → Member.memner_id
- active_hours_start (Field)
- active_hours_end (Field2)
Member_game (일대일 게임)
- team_game_id (PK) — Long — Primary key
- home_member (Field4) — Long
- away_member (Field) — Long
- location (Field2) — String
- winner_member (Field3) — Long
Post (게시물)
- post_id (PK) — Long — Primary key — NOT NULL
- title (Field) — String
- content (Field2) — String
- count (Field3) — Int
- postType (Field4) — Enum
- userId (Field5) — Long
- reported (Field6) — boolean
Team (팀)
- team_id (PK) — Long — Primary key
- memner_id (FK) — Long — Foreign key → Member.memner_id
- team_name (Field1) — Long
- location (Field2) — String
Team_game (팀 게임)
- team_game_id (PK) — Long — Primary key
- home_team (Field4) — Long
- away_team (Field) — Long
- location (Field2) — String
- winner_team (Field3) — Long
main_active_area (메인 활동 지역)
- main_active_area_id (PK) — Primary key — NOT NULL
- memner_id (PK2) — Long — Foreign key → Member.memner_id
- main_location_area (Field) — String
member_video (멤버의 비디오 영상)
- video_id (PK) — Long — Primary key
- member_id (Field) — Long
- video_url (Field2)
- video_resolution (해상도)
particepate_members (팀 게임 참가 멤버들)
- Key (PK) — Primary key — NOT NULL
- team_game_id (FK) — Long — Foreign key → Team_game.team_game_id
- team_id (Field) — Long
- member_id (Field2) — Long
postVideo (게시물 비디오)
- post_video_id (PK) — Long — Primary key — NOT NULL
- post_id (PK2) — Long — Foreign key → Post.post_id — NOT NULL
- post_video_url (Field)
post_images (게시물 이미지)
- post_images_id (PK) — Long — Primary key — NOT NULL
- post_id (FK) — Long — Foreign key → Post.post_id — NOT NULL
- post_image_url (Field) — Long
post_likes (게시물 좋아요)
- post_like_id (PK) — Long — Primary key — NOT NULL
- post_id (PK2) — Long — Foreign key → Post.post_id — NOT NULL
- user_id (Field) — Long
video_analyis (멤버의 비디오 분석)
- video_analysis_id (PK) — Long — Primary key
- video_id (FK) — Long — Foreign key → member_video.video_id