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)