DEV_QUIZ

테이블 (15)

Untitled (POINTS)

  • Key (POINT_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Field (POINT_DATE) — DATE
  • Field (DUE_DATE) — DATE
  • Key (POINT_STATUS) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — CATE_IDX
  • Field (POINT) — NUMBER(10)

Untitled (SCORE)

  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Field (SCORE) — NUMBER(10)
  • Field (RANK) — NUMBER(10)
  • Field (POINT) — NUMBER(10)

Untitled (GAMES)

  • Key (QUIZ_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • Field (QUIZ) — VARCHAR2(1000)
  • Field (POINT) — NUMBER(10)
  • Field (SCORE) — NUMBER(10)
  • Field (EXAMPLE_NO_1) — VARCHAR2(1000)
  • Field (EXAMPLE_NO_2) — VARCHAR2(1000)
  • Field (EXAMPLE_NO_3) — VARCHAR2(1000)
  • Field (EXAMPLE_NO_4) — VARCHAR2(1000)
  • Field (EXAMPLE_NO_5) — VARCHAR2(1000)
  • Field (QUIZ_ORI) — VARCHAR2(100)
  • Field (QUIZ_FILE) — VARCHAR2(100)
  • Key (CATE_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ

Untitled (CATEGORYS)

  • Key (CATE_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • Field (CATE_NAME) — VARCHAR2(30)

Untitled (BOOKMARK)

  • Key (BOOKMARK_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Key (CATE_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ

Untitled (BOARDS)

  • Key (BOARD_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Key (CATE_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ
  • Field (TITLE) — VARCHAR2(300)
  • Field (CONTENT) — VARCHAR2(5000)
  • Field (HIT) — NUMBER(10)
  • Field (REG_DATE) — DATE
  • Field (BOARD_ORI) — VARCHAR2(300)
  • Field (BOARD_FILE) — VARCHAR2(300)

Untitled (COMMENTS)

  • Key (COMM_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Key (BOARD_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ
  • Field (COMM_CONTENT) — VARCHAR2(1000)
  • Field (COMM_DATE) — DATE

Untitled (QUESTIONS)

  • Key (QUESTION_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Field (QUESTION_TITLE) — VARCHAR2(100)
  • Field (QUESTION_CONTENT) — VARCHAR2(5000)
  • Field (QUESTION_ORI) — VARCHAR2(100)
  • Field (QUESTION_FILE) — VARCHAR2(100)
  • Field (QUESTION_DATE) — DATE
  • Field
  • Key (CATE_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ

Untitled (ANSWERS)

  • Key (ANSWER_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • Key (QUESTION_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ
  • Field (CONTENT) — VARCHAR2(5000)
  • Field (ANSWER_ORI) — VARCHAR2(100)
  • Field (ANSWER_FILE) — VARCHAR2(100)
  • Field (ANSWER_DATE) — DATE

Untitled (PRODUCTS)

  • Key (PRODUCT_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • Key (CATE_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ
  • Field (PRODUCT_NAME) — VARCHAR2(300)
  • Field (PRODUCT_ORI) — VARCHAR2(300)
  • Field (PRODUCT_FILE) — VARCHAR2(300)
  • Field (PRODUCT_CONTENT) — VARCHAR2(3000)
  • Field (PRODUCT_PRICE) — NUMBER(10)
  • Field (PRODUCT_CNT) — NUMBER(10)
  • Field (PRODUCT_DATE) — DATE
  • Field (PRODUCT_DEL) — NUMBER(1)
  • Field (PRODUCT_LIKE) — NUMBER(10)

Untitled (CART)

  • Key (CART_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Key (PRODUCT_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ
  • Field (PRODUCT_NUM) — NUMBER(10)
  • Field (CART_DATE) — DATE

Untitled (ORDERS)

  • Key (ORDER_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Field (SUM_PRICE) — NUMBER(10)
  • Field (ORDER_DEL) — NUMBER(1)
  • Field (ORDER_DATE) — DATE

Untitled (ORDERS_DETAILS)

  • Key (ORDER_DETAILS_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • Key (ORDER_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ
  • Key (PRODUCT_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ

Untitled (LIKES)

  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 외래 키 → 멤버.멤버 번호 — NOT NULL — SEQ
  • Key (PRODUCT_IDX) — NUMBER(10) — 외래 키 → Untitled.Key — NOT NULL — SEQ
  • Field (LIKE_DATE) — DATE

멤버 (MEMBERS)

  • 멤버 번호 (MEMBER_IDX) — NUMBER(10) — 기본 키 — NOT NULL — SEQ
  • 아이디 (ID) — VARCHAR2(45)
  • 비밀번호 (PWD) — VARCHAR2(45)
  • 이름 (NAME) — VARCHAR2(30)
  • 닉네임 (NICKNAME) — VARCHAR2(30)
  • 휴대폰번호 (EMAIL) — VARCHAR2(30)
  • 이메일 (PHONE) — VARCHAR2(150)
  • 포인트 (POINT) — NUMBER(10)
  • 가입일 (JOIN_DATE) — DATE
  • Field2 (IS_DEL) — NUMBER(1)
  • Field2 (IS_ADMIN) — NUMBER(1)
  • Field2 (USER_ORI) — VARCHAR2(300)
  • Field2 (USER_FILE) — VARCHAR2(300)