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