sample_app
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
- 댓글 본문 (contents) — 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