lotto

Tables (5)

LOTTO_DRAW_HISTORY

  • DRAW_NO — Number — Primary key — NOT NULL — 회차
  • DRAW_NO_1 — Number — NOT NULL — 번호1
  • DRAW_NO_2 — Number — NOT NULL — 번호2
  • DRAW_NO_3 — Number — NOT NULL — 번호3
  • DRAW_NO_4 — Number — NOT NULL — 번호4
  • DRAW_NO_5 — Number — NOT NULL — 번호5
  • DRAW_NO_6 — Number — NOT NULL — 번호6
  • DRAW_DATE — Date — NOT NULL — 추첨일
  • REGISTRATION_DATE — DateTime — NOT NULL — 등록일

genre (Untitled4)

  • idx (Key) — number — Primary key — NOT NULL — sequence
  • name (Field) — varchar — 장르명
  • idx (Key2) — Number — Foreign key → webtoon.idx — NOT NULL — sequence

info (Untitled2)

  • idx (Key) — Number — Foreign key → webtoon.idx — NOT NULL — sequence
  • score (Field) — Number — 별점
  • review (Field2) — Number — 리뷰수
  • reg_date (Field3) — datetime

platform (Untitled3)

  • idx (Key) — number — Primary key — NOT NULL — sequence
  • name (Field) — varchar — 플랫폼명
  • address_prefix (Field2) — varchar — 주소
  • use_yn (Field3) — boolean — 사용여부

webtoon (Untitled)

  • idx (Key) — Number — Primary key — NOT NULL — sequence
  • title (Field6) — varchar — 웹툰명
  • platform (Field) — varchar — 플랫폼
  • address_surfix (Field2) — varchar — 주소
  • date (Field3) — varchar — 요일
  • writter (Field7) — varchar — 작가명
  • update_date (Field4) — datetime — 수정일
  • registaration_date (Field5) — datetime — 등록일
  • idx (Key2) — number — Foreign key → platform.idx — NOT NULL — sequence
  • infoList (Field8)