golftok

Tables (8)

comment_like (댓글 좋아요)

  • comment_like_id (PK) — not null — Primary key — NOT NULL
  • user_id (users FK) — not null — Foreign key → tok_users.user_id — NOT NULL
  • comment_id (comment FK) — not null — Foreign key → comments.comment_id — NOT NULL

comments (댓글)

  • comment_id (PK) — Primary key — NOT NULL
  • post_id (posts FK) — Foreign key → tok_posts.post_id — NOT NULL
  • user_id (users FK) — Foreign key → tok_users.user_id — NOT NULL
  • comment_text (댓글 내용)
  • upload_date (올린 날짜, 수정 날짜) — not null
  • like_count (좋아요 수) — not null
  • comment_group (댓글 그룹) — not null,
  • group_order (그룹 내 댓글 순서) — not null,
  • group_layer (댓글 깊이) — not null

follow (팔로우)

  • follow_id (PK) — not null — Primary key — NOT NULL
  • user_id (users FK) — Foreign key → tok_users.user_id — NOT NULL
  • friend_id (친구 번호) — not null

hashtag (해시태그)

  • hashtag_id (PK) — not null — Primary key — NOT NULL
  • post_id (posts FK) — Foreign key → tok_posts.post_id — NOT NULL
  • hashtag_content (해시태그 단어) — not null

nasmo (나스모 동영상)

  • nasmo_id (PK) — not null — Primary key — NOT NULL
  • user_id (users FK) — Foreign key → tok_users.user_id — NOT NULL
  • video_root (url 경로) — not null
  • nasmo_thumbnail (썸네일 경로) — not null

post_like (게시물 좋아요)

  • post_like_in (PK) — not null — Primary key — NOT NULL
  • user_id (users FK) — not null — Foreign key → tok_users.user_id — NOT NULL
  • post_id (posts FK) — not null — Foreign key → tok_posts.post_id — NOT NULL

tok_posts (게시물(동영상))

  • post_id (PK) — Primary key — NOT NULL
  • user_id (users FK) — Foreign key → tok_users.user_id — NOT NULL
  • post_content (글 내용)
  • video_root (동영상 저장 경로)
  • upload_date (올린 날짜, 수정 날짜) — not null
  • like_count (좋아요 수) — not null
  • comment_count (댓글 수) — not null
  • locations (위치)
  • post_thumbnail (썸네일 경로) — not null
  • golf_club (골프 클럽)

tok_users (유저)

  • user_id (PK) — Primary key — NOT NULL
  • user_name (유저ID) — not null
  • user_nickname (유저 닉네임) — not null
  • user_password (유저 비밀번호) — not null
  • user_icon (유저 프로필 사진 경로) — not null
  • introduction_message (자기소개)
  • user_grade (골프 등급) — not null
  • following_count (팔로잉 수) — not null
  • follower_count (팔로워 수) — not null
  • role_model (롤모델)
  • handicap (핸디)