sample_tag

Tables (3)

author

  • 저장아이디 (author_id) — int — Primary key — NOT NULL
  • 이름 (name) — varchar(15)
  • 저자소개 (author_info) — varchar(100)
  • 가입일 (createdAt) — timestamp

comment

  • 댓글아이디 (comment_id) — INT — Primary key — NOT NULL
  • 저장아이디 (author_id) — int — Foreign key → author.저장아이디 — NOT NULL
  • 글아이디 (post_id) — Int — Foreign key → post.글아이디 — NOT NULL
  • 저장아이디 (author_id2) — int — Foreign key → post.저장아이디 — NOT NULL
  • 댓글 본문 (content) — TEXT
  • 댓글작성일 (createdAt) — timestamp

post

  • 글아이디 (post_id) — Int — Primary key — NOT NULL
  • 저장아이디 (author_id) — int — Foreign key → author.저장아이디 — NOT NULL
  • 본문 (content) — text
  • 제목 (title) — varchar(100)
  • 작성일 (createdAt) — timestamp