likelionbe
Tables (3)
Comments
- 댓글ID (COMMENT_ID) — BIGINT — Primary key — NOT NULL
- 내용 (CONTENT) — VARCHAR(255)
- 작성일 (CREATE_TIME) — DATE
- 최종수정일 (MODIFY_TIME) — DATE
- 멤버ID (MEMBER_ID) — BIGINT — Foreign key → Members.멤버ID
- 게시글ID (POST_ID) — BIGINT — Foreign key → Posts.게시글ID
Members
- 멤버ID (MEMBER_ID) — BIGINT — Primary key — NOT NULL
- 이메일 (EMAIL) — VARCHAR(255)
- 이름 (NAME) — VARCHAR(255)
Posts
- 게시글ID (POST_ID) — BIGINT — Primary key — NOT NULL
- 제목 (TITLE) — VARCHAR(255)
- 내용 (CONTENT) — VARCHAR(255)
- 멤버ID (MEMBER_ID) — BIGINT — Foreign key → Members.멤버ID
- 작성일 (CREATE_TIME) — DATE
- 최종수정일 (MODIFY_TIME) — DATE