hanghaePost

Tables (4)

COMMENT (comment)

  • COMMENT_ID (comment_id) — BIGINT — Primary key — NOT NULL
  • CONTENT (content) — VARCHAR
  • USER_ID (user_id) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
  • POST_ID (post_id) — BIGINT — Foreign key → POST.POST_ID — NOT NULL

LIKE (like)

  • LIKE_ID (like_id) — BIGINT — Primary key — NOT NULL
  • POST_ID (post_id) — BIGINT — Foreign key → POST.POST_ID — NOT NULL
  • USER_ID (user_id) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL

POST (post)

  • POST_ID (post_id) — BIGINT — Primary key — NOT NULL
  • TITLE (title) — VARCHAR
  • CONTENT (content) — VARCHAR
  • IMAGE (image) — FILE
  • USER_ID (user_id) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL

USERS (users)

  • USER_ID (user_id) — BIGINT — Primary key — NOT NULL
  • USERNAME (username) — VARCHAR
  • PASSWORD (password) — VARCHAR