new OTT

Tables (5)

Group (그룹)

  • Key (그룹번호) — VARCHAR2(10) — Primary key — NOT NULL
  • Key (플렛폼번호) — VARCHAR2(10) — Foreign key → Post.Key — NOT NULL
  • Field (ott계정) — VARCHAR2(10) — NOT NULL
  • Field (ott패스워드) — VARCHAR(128) — NOT NULL

Group_Member (그룹원)

  • Key (그룹번호) — VARCHAR2(10) — Foreign key → Group.Key — NOT NULL
  • Key (플렛폼번호) — VARCHAR2(10) — Foreign key → Group.Key — NOT NULL
  • Field (아이디) — VARCHAR2(10) — Foreign key → Users.Field — NOT NULL
  • Field (결제) — NUMBER(1,0)
  • Field (결제시간) — DATE

OTT_Service (OTT서비스)

  • Key (플렛폼번호) — VARCHAR2(10) — Primary key — NOT NULL
  • Field (인원) — NUMBER(2)

Post (게시물)

  • Key (게시물번호) — Primary key — NOT NULL
  • Key (플렛폼번호) — VARCHAR2(10) — Foreign key → OTT_Service.Key — NOT NULL
  • Field (아이디) — VARCHAR2(10) — Foreign key → Users.Field
  • Field2 (게시글) — VARCHAR2(300) — NOT NULL
  • Field3 (게시내용) — VARCHAR2(300) — NOT NULL
  • Field5 (조회수) — NUMBER(1000)

Users (사용자)

  • Field (아이디) — VARCHAR2(10) — Primary key — NOT NULL
  • Field (이름) — VARCHAR2(10) — NOT NULL
  • Field (이메일) — VARCHAR2(10) — NOT NULL
  • Field2 (생년월일) — DATE — NOT NULL
  • Field3 (비밀번호) — VARCHAR(128) — NOT NULL
  • Field (계좌번호) — VARCHAR2(30)
  • Field (프로필) — VARCHAR(255)