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