tteodeulX2

Tables (3)

comments

  • id — INT — Primary key — NOT NULL
  • user_id — VACHAR(36) — Foreign key → users.id — NOT NULL
  • post_id (poset_id) — INT — Foreign key → posts.id — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE
  • content

posts

  • id — INT — Primary key — NOT NULL
  • user_id — VACHAR(36) — Foreign key → users.id — NOT NULL
  • title — TEXT — NOT NULL
  • image — TEXT — image의 path저장된다.
  • content — TEXT — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE
  • deadline — DATE — NOT NULL
  • like_count — INT — NOT NULL
  • dislike_count — INT — NOT NULL

users

  • id — VACHAR(36) — Primary key — NOT NULL
  • password — VARCHAR(30) — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL
  • last_login — DATE — NOT NULL
  • Profile_image — TEXT — 유저프로필 이미지의 static경로