MINITUBE

Tables (4)

CommentDTO (Untitled4)

  • c_id (Key) — INTEGER — Primary key — NOT NULL
  • c_content (Field) — VARCHAR
  • c_reg_date (Field2) — DATETIME
  • c_mod_date (Field3) — DATETIME
  • c_id (Key2) — INTEGER — Foreign key → CommentDTO.c_id — NOT NULL
  • m_id (Key3) — INTEGER — Foreign key → MemberDTO.m_id — NOT NULL
  • v_id (Key4) — INTEGER — Foreign key → VideoDTO.v_id — NOT NULL

LikeDTO (Untitled3)

  • Key — INTEGER — Primary key — NOT NULL
  • m_id (Key2) — INTEGER — Foreign key → MemberDTO.m_id — NOT NULL
  • v_id (Key3) — INTEGER — Foreign key → VideoDTO.v_id — NOT NULL

MemberDTO (Untitled)

  • m_id (Key) — INTEGER — Primary key — NOT NULL
  • m_mail (Field) — VARCHAR
  • m_pw (Field2) — VARCHAR
  • m_firstname (Field3) — VARCHAR
  • m_lastname (Field4) — VARCHAR
  • m_reg_date (Field5) — DATETIME
  • m_mod_date (Field6) — DATETIME
  • m_profile_img (Field7) — VARCHAR

VideoDTO (Untitled2)

  • v_id (Key) — INTEGER — Primary key — NOT NULL
  • v_title (Field) — VARCHAR
  • v_description (Field2) — VARCHAR
  • v_category (Field3) — VARCHAR
  • v_thumbnail (Field4) — VARCHAR
  • v_video (Field5) — VARCHAR
  • v_reg_date (Field6) — DATETIME
  • v_mod_date (Field7) — DATETIME
  • m_id (Key2) — INTEGER — Foreign key → MemberDTO.m_id — NOT NULL