2-1_GreenLife
Tables (4)
Untitled (Board)
- Key (Board_ID) — BIGINT — Primary key — NOT NULL
- Field (Title) — varchar(200) — NOT NULL — 제목
- Field2 (Contetent) — varchar(200) — NOT NULL — 본문
- Field3 (create_date) — varchar(100) — NOT NULL — 만든 날짜
- Field4 (MEMBER_ID) — BIGINT — NOT NULL — 글쓴이
- Field5 (boardavilable) — tinyInt — NOT NULL — 게시판 삭제 여부
Untitled (file)
- Key — Primary key — NOT NULL
- Field
- Field2
- Field3
Untitled (member)
- Key (id) — BIGINT — Primary key — NOT NULL — 멤버 id
- Field (name) — varchar(20) — NOT NULL — 이름
- Field2 (email) — varchar(50) — NOT NULL — 이메일
- Field3 (password) — varchar(50) — NOT NULL — 비밀번호
- Field (address) — varchar(20) — NOT NULL — 주소
- Field4 (phoneNumber) — varchar(20) — NOT NULL — 핸드폰번호
- Field5 (birthdate) — varchar(20) — NOT NULL — 생일
comment
- pk (COMMENT_ID) — BIGINT — Primary key — NOT NULL
- pk (Board_ID) — BIGINT — Primary key — NOT NULL — 보드 ID
- Field (MEMBER_ID) — BIGINT — NOT NULL — 글쓴이
- Field2 (content) — VARCHAR(200) — NOT NULL — 내용
- Field3 (CREATE_DATE) — VARCHAR(100) — NOT NULL — 등록일
- Field