ㅎㅎ
Tables (4)
Basic (Untitled)
- user_id (Key) — bigint — Primary key — NOT NULL
- user_contents (Field) — text
- user_creator (Field2) — varchar
- user_hitCnt (Field3) — int
- user_title (Field4) — varchar
- user_uploadDate (Field5) — varchar
User_Video (Untitled3)
- uvPNum (Key) — int — Primary key — NOT NULL
- id (Key2) — int — Foreign key → member.id — NOT NULL
- Video_NUM (Key3) — int — Foreign key → Video.Video_NUM — NOT NULL
- PlayTime (Field) — int
- Overlap (Field2) — tinyint
- PlayOn (Field3) — timestamp
- PlayOff (Field4) — timestamp
Video (Untitled2)
- Video_NUM (Key) — int — Primary key — NOT NULL
- Video_Name (Field) — varchar
- Video_time (Field2) — datetime
- Video_Genre (Field3) — varchar
- Video_Upload (Field4) — timestamp
member (회원)
- id (Key) — int — Primary key — NOT NULL
- mail (Field) — varchar
- password (Field2) — varchar
- role (Field3) — varchar
- username (Field4) — varchar