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 (핸디)