erd 생성

테이블 (4)

BIGCOMMENT (Untitled4)

  • bigcomment_seq (PK) — int — 기본 키 — NOT NULL
  • bigcomment_content (Field) — text
  • bigcomment_create_at (Field2) — datetime
  • bigcomment_modified_at (Field3) — datetime
  • comment_seq (FK) — int — 외래 키 → COMMENT.comment_seq — NOT NULL

BOARD (Untitled2)

  • board_seq (PK) — int — 기본 키 — NOT NULL
  • board_title (Field) — varchar(100)
  • board_content (Field2) — text
  • board_create_at (Field3) — datetime
  • board_modified_at (Field4) — datetime
  • user_email (Fk) — varchar(50) — 외래 키 → USER.user_email — NOT NULL

COMMENT (Untitled3)

  • comment_seq (PK) — int — 기본 키 — NOT NULL
  • comment_content (Filed) — text
  • comment_created_at (Field2) — datetime
  • comment_modified_at (Filed3) — datetime
  • board_seq (FK) — int — 외래 키 → BOARD.board_seq — NOT NULL

USER (Untitled)

  • user_email (PK) — varchar(50) — 기본 키 — NOT NULL
  • user_password (Filed) — varchar(100)
  • user_name (Filed2) — varchar(50)
  • user_phone (Filed3) — varchar(20)