Post

Tables (3)

file (파일)

  • id (Key) — Primary key — NOT NULL
  • original_name (원본이름)
  • name (이름)
  • width (넓이)
  • heidth (높이)
  • duration (길이)
  • type (비디오,이미지)
  • created_at (생성일)
  • deleted_at (삭제일)
  • byte_size (파일크기)

post (게시글)

  • id (Key) — Primary key — NOT NULL
  • title (제목)
  • body (내용)
  • created_at (생성일)
  • updated_at (수정일)
  • deleted_at (삭제일)

post_file (게시글_파일)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → post.id — NOT NULL
  • file_id (Key3) — Foreign key → file.id — NOT NULL