국책 최종
테이블 (4)
CLIP
- clip_id — INT — 기본 키 — NOT NULL
- content_id (content_id2) — INT — 외래 키 → CONTENT.content_id — NOT NULL
- content_maker_id (content_maker_id2) — INT — 외래 키 → CONTENT_MAKER.content_maker_id — NOT NULL
- size — VARCHAR(50)
- full_path — VARCHAR(512)
- file_name — VARCHAR(255)
- duration — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
CLIP_MAKER
- clip_maker_id — INT — 기본 키 — NOT NULL
- state — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
CONTENT
- content_id — INT — 기본 키 — NOT NULL
- size — VARCHAR(50)
- category — CHAR(50)
- full_path — VARCHAR(512)
- file_name — VARCHAR(255)
- duration — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
CONTENT_MAKER
- content_maker_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL