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

SECTION (Untitled3)

    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

    schedule (Untitled10)