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