BTS
Tables (30)
CARD (카드)
- id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → EPISODES.id — NOT NULL
CHARGE (충전내역)
- id (Key) — Primary key — NOT NULL
- userId (유저아이디) — Foreign key → USER.id — NOT NULL
- price (결제금액)
COMMENT (댓글)
- id (아이디) — Primary key — NOT NULL
- userId (유저아이디) — Foreign key → USER.id — NOT NULL
- episodeId (에피소드아이디) — Foreign key → EPISODES.id — NOT NULL
- content (내용)
CONTENTS (컨텐츠)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Copy Of CONTENTS2.Key — NOT NULL
Copy Of CONTENTS (CopyOf컨텐츠)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → CONTENTS.Key — NOT NULL
Copy Of CONTENTS2 (CopyOf컨텐츠2)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Copy Of CONTENTS3.Key — NOT NULL
Copy Of CONTENTS3 (CopyOf컨텐츠3)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Copy Of CONTENTS.Key — NOT NULL
Copy Of PAYMENT (CopyOf결제)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → PAYMENT.Key — NOT NULL
Copy Of PAYMENT2 (CopyOf결제2)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → PAYMENT.Key — NOT NULL
Copy Of PAYMENT3 (CopyOf결제3)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Copy Of PAYMENT.Key — NOT NULL
- Key (Key3) — Foreign key → Copy Of PAYMENT2.Key — NOT NULL
Copy Of SECTION (CopyOf섹션)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Copy Of SECTION.Key — NOT NULL
Copy Of SECTION (CopyOf섹션)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → SECTION.Key — NOT NULL
Copy Of SECTION2 (CopyOf섹션2)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Copy Of SECTION.Key — NOT NULL
Copy Of USER (CopyOf사용자)
- Key2 — Primary key — NOT NULL
- Key — Foreign key → USER.Key — NOT NULL
Copy Of USER2 (CopyOf사용자2)
- Key2 — Primary key — NOT NULL
- Key — Foreign key → Copy Of USER3.Key — NOT NULL
Copy Of USER3 (CopyOf사용자3)
- Key — Primary key — NOT NULL
- Key2 — Foreign key → Copy Of USER.Key2 — NOT NULL
EPISODES (회차)
- id (Key) — Primary key — NOT NULL
- contentsId (Key2) — Foreign key → NOVELS.id — NOT NULL
- subject (제목)
- content (내용)
- views (조회수)
- registration (등록일)
- free (무료회차)
EPISODE_HISTORY (최근 본 목록)
- id (아이디) — Primary key — NOT NULL
- userId (유저아이디) — Foreign key → USER.id — NOT NULL
- episodeId (에피소드아이디) — Foreign key → EPISODES.id — NOT NULL
- page (페이지정보) — NOT NULL
LIKE (좋아요)
- id (아이디) — Primary key — NOT NULL
- userId (유저아이디) — Foreign key → USER.id — NOT NULL
- contentsId (컨텐츠아이디) — Foreign key → NOVELS.id — NOT NULL
NOVELS (소설)
- id (Key) — Primary key — NOT NULL
- subject (제목)
- info (소개)
- author (작가)
- publisher (출판사)
- startDate (연재시작일)
- day (연재 요일)
- thumbnail (Field7)
- likeCnt (좋아요수)
- grade (관람등급)
NOVEL_HISTORY (소설내역)
- ID (Key) — Long — Primary key — NOT NULL
- userId (유저id) — Long — Foreign key → USER.ID — NOT NULL
- cardId (카드id) — Long
PAYMENT (결제)
- Key — Primary key — NOT NULL
SECTION (섹션)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Copy Of SECTION2.Key — NOT NULL
STAR_RATING (별점)
- id (Key3) — Primary key — NOT NULL
- userId (유저아이디) — Foreign key → USER.id — NOT NULL
- episodeId (에피소드아이디) — Foreign key → EPISODES.id — NOT NULL
- starRating (평점)
TAG (태그)
- id (아이디) — Primary key — NOT NULL
- contentsId (컨텐츠아이디) — Foreign key → NOVELS.id — NOT NULL
- name (이름)
USER (사용자)
- id (Key) — Primary key — NOT NULL
- email (이메일)
- password (비밀번호)
- name (이름)
- phone (번호)
- age (나이)
- gender (성별)
- interest (관심사)
- point (포인트)
USER (유저)
- ID (Key) — Long — Primary key — NOT NULL
- email (이메일)
- password (비밀번호)
- name (이름)
USER (경계)
- Key — Primary key — NOT NULL
- Key2 — Foreign key → Copy Of USER2.Key2 — NOT NULL