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