가보자

테이블 (9)

advertisement _tb (Untitled7)

  • advertisement_id — Number — 기본 키 — NOT NULL
  • advertisement_category
  • advertisement_name
  • advertisement_title
  • advertisement_image
  • advertisement_width
  • advertisement_heigth
  • advertisement_inDate (advertisement_statDate)
  • advertisement_outDate (advertisement_endDate)
  • advertisement_redirect_URL
  • advertisement_active
  • advertisement_video
  • advertisement_context
  • advertisement_weight

like_tb (Untitled9)

  • like_id (Key) — number — 기본 키 — NOT NULL
  • like_video (Field)
  • like_class (Field2)
  • like_premium (Field3)
  • like_user (Field4)

manager_tb (Untitled4)

  • Manager_id — Number — 기본 키 — NOT NULL
  • Manager_name — VARCHAR2(50)
  • Manager_email — VARCHAR2(50)
  • Field3
  • Field4
  • Field5

pay_tb (Untitled8)

  • pay_id (Key) — number — 기본 키 — NOT NULL
  • pay_date (Field)
  • pay_name (Field2)
  • Field4
  • Field5

premiumInstructor_tb (Untitled5)

  • premium_num — Number — 기본 키 — NOT NULL
  • premium_id — NUMBER — 외래 키 → user_tb.user_id — NOT NULL
  • premium_name
  • premium_inDate
  • premium_outDate
  • premium_profileImage
  • premium_samplePicture
  • premium_sampleVideo
  • premium_introduction
  • premium_subscriptionNum
  • Field7

report_tb (Untitled6)

  • report_id — Number — 기본 키 — NOT NULL
  • report_inDate
  • report_title
  • report_reporter
  • report_image
  • report_content

stage_tb (Untitled2)

  • stage_id — Number — 외래 키 → user_tb.user_id — NOT NULL
  • stage_name
  • stage_bannerImage
  • stage_profileImage
  • stage_subscriptionNum
  • stage_introduction
  • stage_license

user_tb (Untitled)

  • user_id — NUMBER — 기본 키 — NOT NULL
  • user_name — VARCHAR2(10)
  • user_nickname — VARCHAR2(50)
  • user_interest — VARCHAR2(50)
  • user_address — VARCHAR2(100)
  • user_zip — NUMBER
  • user_email — VARCHAR2(50)
  • user_gender — VARCHAR2(50)
  • user_inDate — DATE
  • user_outDate — DATE
  • user_reportNum — NUMBER
  • user_member — VARCHAR2(1)
  • user_subscription — NUMBER

video_tb (Untitled3)

  • video_num — NUMBER — 기본 키 — NOT NULL
  • video_id (user_id) — NUMBER — 외래 키 → user_tb.user_id — NOT NULL
  • video_title — VARCHAR2(50)
  • video_content — VARCHAR2(50)
  • video_category — VARCHAR2(50)
  • video_hit — VARCHAR2(50)
  • video_like — VARCHAR2(50)
  • video_comment — VARCHAR2(50)
  • video_report — VARCHAR2(50)
  • video_motion — VARCHAR2(50)
  • video_public — VARCHAR2(50)
  • video_ageLimit — VARCHAR2(50)
  • video_thumbnail — VARCHAR2(50)
  • video_copyright — VARCHAR2(50)
  • video_class (video_basicsLine) — VARCHAR2(10)