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)