123

Tables (4)

Comment

  • id — BIGINT
  • post_id — BIGINT — Foreign key → Post.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • contents — VARCHAR(255) — NOT NULL
  • reg_date — TIMESTAMP
  • update_date — TIMESTAMP

Post

  • id — BIGINT
  • title — VARCHAR(255)
  • contents — VARCHAR(255)
  • writer — VARCHAR(255)
  • hits — INTEGER
  • likes — INTEGER
  • reg_date — TIMESTAMP
  • update_date — TIMESTAMP
  • deleted_date — TIMESTAMP
  • deleted — BOOLEAN
  • user_id — BIGINT — Foreign key → User.id

Post_Like

  • id — BIGINT
  • post_id — BIGINT — Foreign key → Post.id
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • like_date — TIMESTAMP

User

  • id — BIGINT
  • email — VARCHAR(255)
  • user_name — VARCHAR(255)
  • password — VARCHAR(255)
  • phone — VARCHAR(255)
  • reg_date — TIMESTAMP
  • update_date — TIMESTAMP