OTT
Tables (7)
Comment (댓글)
- Key (댓글번호) — NUMBER(10) — Primary key — NOT NULL
- Key (작성자(회원번호)) — VARCHAR2(10) — Foreign key → Users.Key — NOT NULL
- Key (게시물번호) — NUMBER(10) — Foreign key → Post.Key — NOT NULL
- Field3 (댓글내용) — CLOB
- Field4 (작성날짜) — Date
Group (그룹)
- Key (그룹번호) — VARCHAR2(10) — Primary key — NOT NULL
- Key (결제번호) — VARCHAR2(10) — Foreign key → Payment.Key — NOT NULL
- Field (그룹이름) — VARCHAR2(10)
- Field2 (OTT서비스) — VARCHAR2(10)
Group_Member (그룹멤버)
- Key (그룹번호) — VARCHAR2(10) — Foreign key → Group.Key — NOT NULL
- Key (회원번호) — VARCHAR2(10) — Foreign key → Users.Key — NOT NULL
- Field3 (그룹상태) — VARCHAR2(10)
OTT_Service (OTT서비스)
- Key (플랫폼번호) — VARCHAR2(10) — Primary key — NOT NULL
- Key (결제번호) — VARCHAR2(10) — Foreign key → Payment.Key — NOT NULL
- Field (요금) — NUMBER(10)
- Field2 (쉐어인원) — NUMBER(2) — NOT NULL
- Field3 (진행현황(결제관리)) — VARCHAR2(10)
Payment (결제)
- Key (결제번호) — VARCHAR2(10) — Primary key — NOT NULL
- Field (그룹번호) — VARCHAR2(10)
- Field4 (플랫폼번호) — VARCHAR2(10)
- Field5 (파티장 계좌번호) — VARCHAR2(20)
- Field6 (결제확인) — NUMBER(1) — NOT NULL
Post (게시물)
- Key (게시물번호) — NUMBER(10) — Primary key — NOT NULL
- Key (작성자(회원번호)) — VARCHAR2(10) — Foreign key → Users.Key — NOT NULL
- Field2 (게시일) — Date
- Field3 (게시내용) — VARCHAR2(300)
- Field4 (비밀번호) — VARCHAR2(15)
- Field5 (조회수) — NUMBER(10)
Users (사용자)
- Key (회원번호) — VARCHAR2 — Primary key — NOT NULL
- (아이디) — VARCHAR2(10) — NOT NULL
- (이름) — VARCHAR2(10) — NOT NULL
- (이메일) — VARCHAR2(30) — NOT NULL
- (생년월일) — DATE — NOT NULL
- (비밀번호) — VARCHAR2(15) — NOT NULL