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