DB 설계

테이블 (12)

AdOrder (Untitled5)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • id (Key2) — INT UNSIGNED — 외래 키 → AdPublisher.id — NOT NULL

AdOrderHistory (CopyOfUntitled5)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Key (Key2) — 외래 키 → AdOrder.Key — NOT NULL

AdPublisher (CopyOfUntitled4)

  • id (Key) — INT UNSIGNED — 기본 키 — NOT NULL
  • login_id (Field) — VARCHAR(30) — NOT NULL
  • password (Field2) — VARCHAR(256) — NOT NULL
  • name (Field3) — VARCHAR(30) — NOT NULL
  • email (Field4) — VARCHAR(30) — NOT NULL
  • phone_number (Field5) — VARCHAR(11) — NOT NULL
  • gender (Field6) — ENUM — NOT NULL
  • state (Field9) — ENUM — NOT NULL
  • created_at (Field7) — DATETIME — NOT NULL
  • updated_at (Field8) — DATETIME — NOT NULL
  • user_img (Field10) — VARCHAR(300)
  • Key (Key2) — 외래 키 → Payment.Key — NOT NULL

Admin (CopyOfUntitled3)

  • id (Key) — INT UNSIGNED — 기본 키 — NOT NULL
  • login_id (Field) — VARCHAR(30) — NOT NULL
  • password (Field2) — VARCHAR(256) — NOT NULL
  • name (Field3) — VARCHAR(30) — NOT NULL
  • email (Field4) — VARCHAR(30) — NOT NULL
  • phone_number (Field5) — VARCHAR(11) — NOT NULL
  • gender (Field6) — ENUM — NOT NULL
  • state (Field9) — ENUM — NOT NULL
  • created_at (Field7) — DATETIME — NOT NULL
  • updated_at (Field8) — DATETIME — NOT NULL
  • user_img (Field10) — VARCHAR(300)

Channel (CopyOfCopyOfUntitled2)

  • id (Key) — INT UNSIGNED — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

GoogleAds (Untitled3)

  • Key — 기본 키 — NOT NULL
  • id (Key2) — INT UNSIGNED — 외래 키 → Channel.id — NOT NULL
  • Key (Key3) — 외래 키 → AdOrder.Key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

Payment (Untitled4)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Subscription (CopyOfUntitled2)

  • id (Key) — INT UNSIGNED — 기본 키 — NOT NULL
  • id (Key2) — INT UNSIGNED — 외래 키 → Channel.id — NOT NULL
  • id (Key3) — INT UNSIGNED — 외래 키 → User.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

User (Untitled)

  • id (Key) — INT UNSIGNED — 기본 키 — NOT NULL
  • login_id (Field) — VARCHAR(30) — NOT NULL
  • password (Field2) — VARCHAR(256) — NOT NULL
  • name (Field3) — VARCHAR(30) — NOT NULL
  • email (Field4) — VARCHAR(30) — NOT NULL
  • phone_number (Field5) — VARCHAR(11) — NOT NULL
  • gender (Field6) — ENUM — NOT NULL
  • state (Field9) — ENUM — NOT NULL
  • created_at (Field7) — DATETIME — NOT NULL
  • updated_at (Field8) — DATETIME — NOT NULL
  • user_img (Field10) — VARCHAR(300)

Video (CopyOfUntitled)

  • id (Key) — INT UNSIGNED — 기본 키 — NOT NULL
  • updated_at (Field8) — DATETIME — NOT NULL
  • thumbnail_url (Field10) — VARCHAR(300) — NOT NULL
  • title (Field) — VARCHAR(20) — NOT NULL
  • description (Field2) — VARCHAR(200)
  • state (Field9) — ENUM — NOT NULL
  • created_at (Field7) — DATETIME — NOT NULL

ViewingHistory (Untitled2)

  • Key — 기본 키 — NOT NULL
  • id (Key2) — INT UNSIGNED — 외래 키 → User.id — NOT NULL
  • id (Key3) — INT UNSIGNED — 외래 키 → Video.id — NOT NULL
  • Field2
  • Field3
  • Field4
  • Field5

YoutubeGuide (CopyOfUntitled22)

  • Key — 기본 키 — NOT NULL
  • id (Key2) — INT UNSIGNED — 외래 키 → Admin.id — NOT NULL
  • id (Key3) — INT UNSIGNED — 외래 키 → Video.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4