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