Prostargram
Tables (25)
Copy Of COMMENT (COMMENT_OF_DEBATE_POST)
- commentId — INT UNSIGNED — Primary key — NOT NULL
- Key (choice_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- commentId (parent_id) — INT UNSIGNED — Foreign key → Copy Of COMMENT.commentId
- content — VARCHAR(300) — NOT NULL
- Field (like_count) — INT UNSIGNED — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
Copy Of Copy Of Untitled (STATISTICS_POST_HASHTAG_MAPPING)
- Key (id) — INT UNSIGNED — Primary key — NOT NULL
- Key (hashtag_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
Copy Of Copy Of Untitled3 (COMMENT_OF_DEBATE_POST_LIKE)
- like_id — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- commentId — INT UNSIGNED — Foreign key → Copy Of COMMENT.commentId — NOT NULL
Copy Of Untitled (DEBATE_POST_HASHTAG_MAPPING)
- Key (id) — INT UNSIGNED — Primary key — NOT NULL
- Key (hashtag_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
Copy Of Untitled2 (COMMENT_OF_STATISTICS_POST)
- commentId — INT UNSIGNED — Primary key — NOT NULL
- Key (post_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- commentId (parent_id) — INT UNSIGNED — Foreign key → Copy Of Untitled2.commentId — NOT NULL
- content — VARCHAR(300) — NOT NULL
- Field (like_count) — INT UNSIGNED — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
Copy Of Untitled3 (COMMENT_OF_STATISTICS_POST_LIKE)
- like_id — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- commentId — INT UNSIGNED — Foreign key → Copy Of Untitled2.commentId — NOT NULL
POST (NORMAL_POST)
- post_id — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- Field (like_count) — INT UNSIGNED — NOT NULL
- Field (content) — VARCHAR(300)
POST_LIKE (LIKE_OF_NORMAL_POST)
- like_id — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- post_id — INT UNSIGNED — Foreign key → POST.post_id — NOT NULL
Untitled (USER_CHOICE_OF_DEBATE_POST_MAPPING)
- Key (choice_id) — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- Key (post_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Field (option_num) — TINYINT(2) — NOT NULL
Untitled (USERS)
- user_id — INT UNSIGNED — Primary key — NOT NULL
- Key (group_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Field (email) — TEXT — NOT NULL — 이메일 최대길이 320자 이하로 체크 로직 필요
- Field (password) — TEXT — github 연동 회원가입은 password가 필요 없음
- Field2 (self_introduction) — TEXT — 자기소개 300자 이하로 체크 로직 필요
- Field (profile_img_url) — TEXT — NOT NULL — /카톡 프사 이미지 기본으로 넣을꺼임
- post_count — INT UNSIGNED — NOT NULL
- Field (follower_count) — INT UNSIGNED — NOT NULL
- Field (following_count) — INT UNSIGNED — NOT NULL
- Field (status) — CHAR(21) — NOT NULL — 영구정지(permanently suspended), 정지(suspended), 정상(ACTIVE)
- Field (login_type) — CHAR(6) — NOT NULL — GITHUB,NORMAL
Untitled (FOLLOW)
- follow_id — INT UNSIGNED — Primary key — NOT NULL
- to_user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- from_user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
Untitled (COMMENT_OF_NORMAL_POST)
- commentId — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- post_id — INT UNSIGNED — Foreign key → POST.post_id — NOT NULL
- commentId (parent_id) — INT UNSIGNED — Foreign key → Untitled.commentId
- content — VARCHAR(300) — NOT NULL
- Field (like_count) — INT UNSIGNED — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
Untitled (COMMENT_OF_NORMAL_POST_LIKE)
- like_id — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- commentId (comment_id) — INT UNSIGNED — Foreign key → Untitled.commentId — NOT NULL
Untitled (profile1)
- Key (name) — Primary key — NOT NULL
- Field
- Field2
- Key (age) — Foreign key → Untitled2.Key — NOT NULL
- Key (age2) — Foreign key → Untitled2.Key — NOT NULL
Untitled (HASHTAGS)
- Key (hashtag_id) — INT UNSIGNED — Primary key — NOT NULL
- Field (name) — VARCHAR(15) — NOT NULL
Untitled (NORMAL_POST_HASHTAG_MAPPING)
- Key (id) — INT UNSIGNED — Primary key — NOT NULL
- Key (hashtag_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- post_id — INT UNSIGNED — Foreign key → POST.post_id — NOT NULL
Untitled (DEBATE_POST)
- Key (post_id) — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- Field (option1) — VARCHAR(100) — NOT NULL
- Field (option2) — VARCHAR(100) — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
Untitled (USER_CHOICE_OF_STATISTICS_POST_MAPPING)
- Key (id) — INT UNSIGNED — Primary key — NOT NULL
- Key (option_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
Untitled (CHOICE_OF_STATISTICS_POST)
- Key (option_id) — INT UNSIGNED — Primary key — NOT NULL
- Key (post_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Field (content) — CHAR(40) — NOT NULL
Untitled (STATISTICS_POST)
- Key (post_id) — INT UNSIGNED — Primary key — NOT NULL
- Field3 (content) — TEXT — NOT NULL
- Field (start_time) — DATE — NOT NULL
- Field2 (end_time) — DATE — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
Untitled (HYPER_LINK)
- Key (link_id) — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL — 유저는 3개까지의 링크를 가질 수 있음.
- Field (link) — TEXT — NOT NULL
Untitled (GROUP)
- Key (group_id) — INT UNSIGNED — Primary key — NOT NULL
- Field (name) — VARCHAR(40) — NOT NULL
- Field2 (domain) — VARHCAR(65) — NOT NULL
- Field (type) — CHAR(7) — NOT NULL — SCHOOL / COMPANY (ENUM으로 쓰는게 좋을듯?)
Untitled (IMAGE)
- Key (image_id) — INT UNSIGNED — Primary key — NOT NULL
- post_id — INT UNSIGNED — Foreign key → POST.post_id — NOT NULL
- Field (img_url) — TEXT — NOT NULL
Untitled (INTERESTS)
- Key (id) — INT UNSIGNED — Primary key — NOT NULL
- user_id — INT UNSIGNED — Foreign key → Untitled.user_id — NOT NULL
- Key (hashtag_id) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
Untitled2 (profile2)
- Key (age) — Primary key — NOT NULL
- Field
- Field2
- Key (name) — Foreign key → Untitled.Key — NOT NULL
- Key (name2) — Foreign key → Untitled.Key — NOT NULL