Board Project
Tables (3)
Copy Of COMMENT (CopyOf댓글)
- ID (댓글아이디) — BIGINT — Primary key — NOT NULL
- USER_ID (사용자아이디2) — BIGINT — Foreign key → USER.ID — NOT NULL
- POST_ID (게시글 아이디) — BIGINT — Foreign key → Posts.ID — NOT NULL
- USER_NAME (작성자 이름) — VARCHAR — NOT NULL
- COMMENT (내용) — VARCHAR — NOT NULL
- CREATEDATE (생성일) — DATETIME — NOT NULL
- MODIFIEDDATE (수정일) — DATETIME — NOT NULL
Posts (게시물)
- ID (아이디) — BIGINT — Primary key — NOT NULL
- USER_ID (사용자 아이디) — BIGINT — Foreign key → USER.ID — NOT NULL
- TITLE (제목) — TEXT — NOT NULL
- CONTENT (내용) — VARCHAR — NOT NULL
- AUTHOR (작성자) — VARVHAR — NOT NULL
- VIEW (조회수) — INTEGER — NOT NULL
- ectDate (작성일) — VARCHAR — NOT NULL
- CREATE_DATE (생성일) — DATETIME — NOT NULL
- MODIFIED_DATE (수정일) — DATETIME — NOT NULL
USER (사용자)
- ID (사용자아이디) — BIGINT — Primary key — NOT NULL
- NAME (사용자이름) — VARCHAR — NOT NULL
- EMAIL (이메일) — VARCHAR — NOT NULL
- PICTURE (사진) — VARVHAR — NOT NULL
- ROLE (권한) — VARCHAR — NOT NULL
- CREATEDATE (생성일) — DATETIME — NOT NULL
- MODIFIEDDATE (수정일) — DATETIME — NOT NULL