board

Tables (3)

Member (회원)

  • id (Key) — Primary key — NOT NULL
  • user_id (회원아이디) — varchar
  • password (비밀번호) — varchar
  • email (이메일) — varchar
  • phone (핸드폰) — varchar

Photo (사진)

  • id (Key) — Primary key — NOT NULL
  • post_id (게시글아이디) — Foreign key → Post.id — NOT NULL
  • member_id (회원아이디) — Foreign key → Post.member_id — NOT NULL
  • upload_file_name (업로드 파일명) — varchar
  • store_file_name (저장 파일명) — varchar
  • write_time (작성시간) — timestamp
  • update_time (수정시간) — timestamp

Post (게시글)

  • id (Key) — Primary key — NOT NULL
  • member_id (회원아이디) — Foreign key → Member.id — NOT NULL
  • title (제목) — varchar
  • content (내용) — varchar
  • write_time (작성시간) — timestamp
  • update_time (수정시간) — timestamp