//강사님 양념 추가
table user{ // 사용자
idx bigint [pk, not null, increment]
email varchar(50) [not null]
pw varchar(20) [not null, unique]
}
Table profile{ //프로필 세분화
idx bigint [pk, not null, increment]
pname varchar(20) [not null]
u_idx bigint
ki_mode boolean [not null, default: false]
}
table is_msd{
idx bigint [pk, not null, increment]
name varchar(20) [not null]
}
Table vidio{ //동영상
idx bigint [pk, not null, increment]
is_msd bigint //영화, 시리즈, 드라마
vname varchar [not null]
v_text text [not null] //설명
v_link text [not null] //비디오 링크
age tinyint [not null, default: 0] //권장연령
}
Table actors{ //배우
idx bigint [pk, not null, increment]
name varchar(30) [not null]
}
Table a_v_bridge{ //배우 출연목록 보려고 만듬
idx bigint [pk, not null, increment]
a_idx bigint
v_idx bigint
}
Table tage{ //카테고리
idx bigint [pk, not null, increment]
tname varchar [not null]
}
table t_v_bridg{ //카테고리 리스트 보려고 만듬
idx bigint [pk, not null, increment]
v_IDX bigint
t_idx bigint
}
Table list{ //시청기록
idx bigint [pk, not null, increment]
p_idx bigint
v_idx bigint
}
Table like{ //좋아요
idx bigint [pk, not null, increment]
p_idx bigint
v_idx bigint
}
Table GG{ //찜
idx bigint [pk, not null, increment]
p_idx bigint
v_idx bigint
}
ref: profile.u_idx > user.idx [delete: cascade]
ref: list.p_idx > profile.idx [delete: cascade]
Ref: list.v_idx > vidio.idx [delete: cascade]
ref: like.p_idx > profile.idx [delete: cascade]
Ref: like.v_idx > vidio.idx [delete: cascade]
ref: GG.p_idx > profile.idx [delete: cascade]
Ref: GG.v_idx > vidio.idx [delete: cascade]
Ref: a_v_bridge.a_idx > actors.idx [delete: cascade]
ref: a_v_bridge.v_idx > vidio.idx [delete: cascade]
ref: t_v_bridg.v_IDX > vidio.idx [delete: cascade]
ref: t_v_bridg.t_idx > tage.idx [delete: cascade]
ref: vidio.is_msd > is_msd.idx