youtube
Tables (5)
advertise (광고)
- advertise_idx (Key) — int — Primary key — NOT NULL
- advertise_name (Field) — varchar(200)
- advertise_count (Field2) — int
category (카테고리)
- category_idx (Key) — int — Primary key — NOT NULL
- category_name (Field) — varchar(100)
- category_detail (Field2) — varchar(40)
comment (댓글)
- comment_idx (Key) — int — Primary key — NOT NULL
- video_idx (Key2) — int — Foreign key → video.video_idx — NOT NULL
- comment_author (Field) — int
- comment_content (Field2) — varchar(200)
- comment_createdAt (Field3) — datetime
- user_idx (Key3) — int — Foreign key → user.user_idx — NOT NULL
- comment_updatedAt (Field4) — datetime
user (사용자)
- user_idx (Key) — int — Primary key — NOT NULL
- user_id (Field) — varchar(20)
- user_password (Field2) — varchar(20
- user_createdAt (Field3) — datetime
video (비디오)
- video_idx (Key) — int — Primary key — NOT NULL
- video_url (Field) — varchar(200)
- category_idx (Key2) — int — Foreign key → category.category_idx — NOT NULL
- video_title (Field2) — varchar(200)
- video_detail (Field3) — varchar(200)
- user_idx (Key3) — int — Foreign key → user.user_idx — NOT NULL
- video_createdAt (Field4) — datetime
- Field5