photo 고도화

테이블 (3)

files (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(127)
  • bucket (Field2) — varchar(127)
  • object_key (Field3) — varchar(127)
  • url (Field4) — varchar(255)
  • type (Field5) — varchar(63)
  • size (Field6) — int unsigned
  • md5 (Field7) — char(32)
  • created_at (Field8) — datetime

photo_content_links (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • photo_id (Key2) — bigint — 외래 키 → photos.id — NOT NULL
  • type (Field) — varchar(255)
  • contents_id (Field2) — bigint

photos (사진)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • file_id (Key2) — bigint — 외래 키 → files.id — NOT NULL
  • type (Field2) — varchar(32)
  • title (Field4) — varchar(127)
  • description (Field5) — varchar(255)
  • origin (Field7) — varchar(255)
  • memo (Field8) — text
  • org_id (Field12) — int
  • disabled (Field9) — tinyint(1)
  • height (Field3) — int
  • width (Field) — int
  • created_at (Field10) — datetime
  • updated_at (Field11) — datetime