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)