practice

Tables (5)

comment (댓글)

  • comment_ID (key) — bigint — Primary key — NOT NULL
  • POST_ID (Key) — bigint — Foreign key → post_table.POST_ID — NOT NULL
  • writer (user_id) — bigint
  • content — CHAR
  • comment_good_count (.) — bigint

log in (private)

  • ID (Key) — bigint — Primary key — NOT NULL
  • user_id — NOT NULL
  • password — NOT NULL

post_table (게시물)

  • POST_ID (Key) — bigint — Primary key — NOT NULL
  • poster (user_id) — bigint
  • content — NOT NULL
  • attached file — ? — NOT NULL
  • good_count — bigint
  • written_time (when) — bigint
  • view_count — bigint

re-comment (대댓글)

  • comment_ID (key) — bigint — Primary key — NOT NULL
  • comment_ID (key2) — bigint — Foreign key → comment.comment_ID — NOT NULL
  • POST_ID (Key) — bigint — Foreign key → comment.POST_ID — NOT NULL
  • writer (user_id) — bigint
  • content — CHAR

user

  • ID (Key) — bigint — Primary key — NOT NULL
  • user_id — NOT NULL
  • password — NOT NULL
  • user_role — CHAR — NOT NULL
  • activity — CHAR
  • user_title — CHAR
  • background (picture) — PNG
  • weed — NOT NULL
  • Hashtag (hashtag) — CHAR
  • user_post — bigint
  • user_comment (comment) — bignit
  • user_profile (user_picture) — PNG
  • user_email (email) — NOT NULL
  • enabled — bit