ㅎㅎ

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