OTT_ERD

Tables (15)

Contents (contents)

  • Contents Code (contents_code) — nvarchar2(15) — Primary key — NOT NULL
  • Contents Title (contents_title) — nvarchar2(25)
  • Contents Director (contents_director) — nvarchar2(15)
  • Contents Production Year (contents_p_year) — date
  • Contents Genre (contents_genre) — nvarchar2(15)
  • Contents Primary Actor (contents_p_actor) — nvarchar2(20)
  • Contents Explanation (contents_explanation) — naverchar2(300)
  • Genre Code (gerne_code) — nvarchar2(15) — Foreign key → Genre.Genre Code — NOT NULL

Genre (genre)

  • Genre Code (gerne_code) — nvarchar2(15) — Primary key — NOT NULL
  • Genre Name (genre_name) — nvarchar2(15)

Live Chat (live chat)

  • Chat ID (chat_id) — nvarchar2(25) — Primary key — NOT NULL
  • Detail (detail) — nvarchar2(100)
  • Date (date) — datetime
  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Party Code (party_code2) — nvarchar2(20) — Foreign key → Party.Party Code — NOT NULL

Member (memeber)

  • Member ID (member_id) — nvarchar2(20) — Primary key — NOT NULL
  • Member Name (member_name) — nvarchar2(20)
  • Member Password (member_pw) — varchar2(20)
  • Subscription Type (subscription_YN) — boolean

Party (party)

  • Party Code (party_code) — nvarchar2(20) — Primary key — NOT NULL
  • Party Name (party_name) — nvarchar2(15)
  • Party Maker ID (p_maker_id) — naverchar2(20)
  • Party Member ID (p_member_id) — nvarchar2(20)
  • Party Date (party_date) — date
  • Contents Code (contents_code2) — nvarchar2(15) — Foreign key → Contents.Contents Code — NOT NULL
  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL

Pay (pay)

  • Member ID (member_id) — nvarchar2(20) — Foreign key → Subscription.Member ID — NOT NULL
  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Payment (payment) — nvarchar2(20)
  • Pay Date (paydate) — date
  • Pay Price (price) — number(20)

Profile (profile)

  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Profile_image (profile_image) — blob
  • Nickname (nickname) — nvarchar2(15)

Purchase (purchase)

  • Purchase ID (purchase_id) — nvarchar2(20) — Primary key — NOT NULL
  • Purchase Date (purchase_date) — date
  • Contents Code (contents_code2) — nvarchar2(15) — Foreign key → Contents.Contents Code — NOT NULL
  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Pay.Member ID — NOT NULL
  • Member ID (member_id) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Member ID (member_id22) — nvarchar2(20) — Foreign key → Pay.Member ID — NOT NULL

Recommend (recommend)

  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Contents Code (contents_code2) — nvarchar2(15) — Foreign key → Contents.Contents Code — NOT NULL
  • Contents Title (contents_title) — nvarchar2(15)
  • Genre Code (gerne_code) — nvarchar2(15) — Foreign key → Genre.Genre Code — NOT NULL

Review (review)

  • Comment Time (comment_time) — datetime — Primary key — NOT NULL
  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Comment ID (comment_id) — nvarchar2(20)
  • Comment Detail (comment_detail) — nvarchar2(300)
  • Score (score) — number
  • Contents Code (contents_code) — nvarchar2(15) — Foreign key → Contents.Contents Code — NOT NULL

Save (save)

  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Contents Code (contents_code2) — nvarchar2(15) — Foreign key → Contents.Contents Code — NOT NULL

Search (search)

  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Search Date (search_date) — date
  • Detail (detail) — nvarchar2(20)

Subscription (subscription)

  • Member ID (member_id) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Subscription Plan (subscription_plan) — nvarchar2(20)
  • Subscription Start Date (subscription_s_date) — date
  • Subscription Finish Date (subscription_f_date) — date

Watch (watch)

  • Play Date (play_date) — date — Primary key — NOT NULL
  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Contents Code (contents_code2) — nvarchar2(15) — Foreign key → Contents.Contents Code — NOT NULL
  • Play Starting Point (play_start) — time
  • Play Finishing Point (play_finish) — time

Wish List (wish list)

  • Member ID (member_id2) — nvarchar2(20) — Foreign key → Member.Member ID — NOT NULL
  • Contents Code (contents_code2) — nvarchar2(15) — Foreign key → Contents.Contents Code — NOT NULL