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