국책 최종

테이블 (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