GodzipFinal

Tables (12)

ADMIN

  • NO — NUMBER
  • ADMIN_ID — VARCHAR2(20)
  • ADMIN_PWD — NUMBER(20)

CATEGORY

  • NO — NUMBER — Primary key — NOT NULL
  • CA_NAME — VARCHAR2(100)
  • CA_INFO — VARCHAR2(255)
  • CA_IMG — VARCHAR2(400)

COMM

  • NO — NUMBER — Primary key — NOT NULL
  • REVIEW_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(1000)
  • POST_DATE — TIMESTAMP
  • IS_UPDATE_YN — CHAR(1)

FAQ

  • NO — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(100)
  • CONTENT — VARCHAR2(4000)
  • ADMIN_NO — NUMBER — NOT NULL
  • DELETE_YN — CHAR(1)

GRADE

  • NO — NUMBER — Primary key — NOT NULL
  • GRADE — VARCHAR2(10)
  • GRADE_INFO — VARCHAR2(255)

INQUIRY_TYPE

  • NO — NUMBER — Primary key — NOT NULL
  • TYPE — VARCHAR2(100) — NOT NULL

LOGIN_TYPE

  • NO — NUMBER
  • TYPE — VARCHAR2(100) — NOT NULL

MEMBER_INFO

  • NO — NUMBER — Primary key — NOT NULL
  • GRADE_NO — VARCHAR2(20)
  • ID — VARCHAR2(20) — NOT NULL
  • PWD — VARCHAR2(100)
  • NICK — VARCHAR2(20)
  • ENROLL_DATE — DATE
  • QUIT_YN — CHAR(1)
  • IS_BLOCKED_YN — CHAR(1)
  • EMAIL — VARCHAR2(200)
  • LAST_VISIT — DATE
  • VISITED_DAYS — NUMBER
  • PROFILE — VARCHAR2(200)

QNA

  • NO — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(100)
  • CONTENT — VARCHAR2(4000)
  • ANSWER — VARCHAR2(4000)
  • MEMBER_NO — NUMBER — NOT NULL
  • ADMIN_NO — NUMBER
  • COUNT — NUMBER
  • ENROLL_DATE — TIMESTAMP
  • ANSWER_DATE — TIMESTAMP
  • DELETE_YN — CHAR(1)
  • ANSWERED_YN — CHAR(1)
  • EDIT_DATE — TIMESTAMP
  • TYPE — VARCHAR2(200)

REVIEW

  • NO — NUMBER — Primary key — NOT NULL
  • CATEGORY_NO — NUMBER — NOT NULL
  • SUB_CA_NO — NUMBER — NOT NULL
  • PROD_NAME — VARCHAR2(400) — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • TITLE — VARCHAR2(400)
  • CONTENT — VARCHAR2(4000)
  • SCORE — NUMBER
  • IS_LIKE — NUMBER
  • PURCHASE_DATE — DATE
  • ATT_FILE — VARCHAR2(300)
  • POST_DATE — DATE
  • COMM_COUNT — NUMBER
  • IS_UPDATE_YN — CHAR(1)
  • DELETE_YN — CHAR(1)
  • COUNT — NUMBER

REVIEW_LIKE (좋아여)

  • LIKENO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER
  • REVIEW_NO — NUMBER
  • CLICK_TIME — DATE

SUBDIVISION

  • NO — NUMBER — Primary key — NOT NULL
  • CA_NO — NUMBER — NOT NULL
  • SUB_CATEGORY — VARCHAR2(200)