Paper-Project-ERD

Tables (4)

Attached Image (attached_img)

  • 첨부된 사진 ID (attached_image_id) — INT(10) — Primary key — NOT NULL
  • 게시물ID (posting_id) — INT(10) — Foreign key → Posting.게시물ID
  • 첨부된 사진 (images) — varchar(100)

Content (content)

  • 게시물ID (posting_id) — INT(10) — Foreign key → Posting.게시물ID
  • 게시물 내용 (posting_content) — TEXT

Personal Data (personal_data)

  • 고유 ID (inherent_id) — int(10) — Primary key
  • 아이디 (user_id) — VARCHAR(20)
  • 패스워드 (user_password) — VARCHAR(20)
  • 닉네임 (user_nickname) — VARCHAR(20)

Posting (posting)

  • 게시물ID (posting_id) — INT(10) — Primary key
  • 고유 ID (inherent_id) — int(10) — Foreign key → Personal Data.고유 ID
  • 제목 (posting_title) — VARCHAR(20)
  • 게시물 생성 시간 (posting_gen_time) — DATETYPE