youtube
Tables (4)
SUBSCRIPTION (Untitled3)
- SUBSCRIPTION_ID (Key) — BIGINT — Primary key — NOT NULL
- USER_ID (PK) — BIGINT — Foreign key → user.USER_ID — NOT NULL
VIDEO (Untitled2)
- VIDEO_ID (Key) — BIGINT — Primary key — NOT NULL
- CATEGORY_ID (Key2) — BIGINT — Foreign key → category.CATEGORY_ID — NOT NULL
- USER_ID (PK) — BIGINT — Foreign key → user.USER_ID — NOT NULL
- TITLE (Field) — VARCHAR — NOT NULL
- CONTENT (Field2) — VARCHAR
category (Untitled)
- CATEGORY_ID (Key) — BIGINT — Primary key — NOT NULL
- NAME (Field) — VARCHAR — NOT NULL — UNIQUE
user (사용자)
- USER_ID (PK) — BIGINT — Primary key — NOT NULL
- EMAIL (Field) — VARCHAR — NOT NULL — UNIQUE
- PASSWORD (Field2) — VARCHAR — NOT NULL — UNIQUE
- NICKNAME (Field3) — VARCHAR — NOT NULL — UNIQUE
- PHONE_NUMBER (Field4) — VARCHAR — NOT NULL — UNIQUE