new board
Tables (4)
Board (게시판)
- id (아이디) — int — Primary key — NOT NULL
- title (제목) — varchar(200)
- content (내용) — varchar(255)
- writer (글쓴이) — varchar(255)
- createdate (날짜) — timestamp
- updatedate (수정날짜) — datetime
- hits (조회수) — int
Comment (댓글)
- reply_id (댓글계정) — int — Primary key — NOT NULL
- post_id (계정) — int
- user_id (댓글) — varchar(200)
- title (제목) — varchar(255)
- content (내용) — varchar(255)
- regdate (작성일) — date
- chdate (수정일자) — date
- parent_id (부모댓글) — varchar
Member (Untitled2)
- user_id (Key) — int — Primary key — NOT NULL
- username (유저명) — varchar
- password (비밀번호) — varchar
- email (이메일) — varchar
- address (주소) — varchar(300)
- phone (폰번호) — number
image (프로필이미지)
- title (제목) — varchar(255) — Primary key — NOT NULL
- id (아이디) — varchar(255)
- user_id (파일명) — varchar(255)
- post_image_url (이미지) — varchar(200)
- caption (Field) — varchar(255)
- createdate (글날짜) — datetime