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