miniproject

Tables (6)

POST

  • post_id — Int — Primary key
  • post_title (post-title) — varchar — NOT NULL
  • post_content — text
  • post_image
  • create_time — DateTime
  • update_time — DateTime
  • user_id (user_id2) — int — Foreign key → Users.user_id — NOT NULL

Users

  • user_id — int — Primary key — NOT NULL
  • user_pw — varchar
  • user_email — varchar
  • create_time — DateTime
  • update_time — DateTime

admin

  • admin_id — Int — Primary key — NOT NULL

comments

  • commentId — int — Primary key — NOT NULL
  • content — text
  • user_id — int
  • create_time — DateTime
  • update_time — DateTime
  • post_id (post_id2) — Int — Foreign key → POST.post_id

likes

  • user_id — int — Primary key — NOT NULL
  • create_time — DateTime
  • update_time — DateTime
  • post_id (post_id2) — Int — Foreign key → POST.post_id

rank

  • rank_id — Integer — Primary key — NOT NULL
  • rank_name — varchar
  • user_id — int — Foreign key → Users.user_id — NOT NULL