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