TouchPoint-All
Tables (12)
ANSWER
- ANSWER_NO — NUMBER
- ANSWER_TITLE — VARCHAR2(200 BYTE) — NOT NULL
- ANSWER_CONTENT — VARCHAR2(500 BYTE) — NOT NULL
- ANSWER_DATE — DATE — NOT NULL
- QNA_NO — NUMBER — NOT NULL
CERTIFICATION
- USER_ID — VARCHAR2(30 BYTE)
- EMAIL — VARCHAR2(255 BYTE) — NOT NULL
- CERTIFICAION_NUMBER — VARCHAR2(6 BYTE) — NOT NULL
FAQ
- FAQ_NO — NUMBER
- FAQ_TITLE — VARCHAR2(50 BYTE) — NOT NULL
- ANSWER — VARCHAR2(500 BYTE) — NOT NULL
FILE_ADD
- FILE_NO — NUMBER
- ORIGIN_NAME — VARCHAR2(100 BYTE) — NOT NULL
- CHANGE_NAME — VARCHAR2(100 BYTE) — NOT NULL
- QNA_NO — NUMBER — NOT NULL
- ANSWER_NO — NUMBER
- PATH — VARCHAR2(255 BYTE) — NOT NULL
LOGIN_ATTEMPT
- ATTEMPT_ID — NUMBER
- USER_ID — VARCHAR2(20 BYTE) — Foreign key → USERS.USER_ID — NOT NULL
- FAILED_LOGIN_CNT — NUMBER — NOT NULL
- CAPTCHA_ACTIVE — CHAR(1 BYTE) — NOT NULL
QNA
- QNA_NO — NUMBER
- QNA_TITLE — VARCHAR2(50 BYTE) — NOT NULL
- QNA_CONTENT — VARCHAR2(500 BYTE) — NOT NULL
- QNA_DATE — DATE — NOT NULL
- USER_ID — VARCHAR2(20 BYTE) — NOT NULL
- PHONE_NO — NUMBER
- STATUS — VARCHAR2(20 BYTE)
TB_HISTORY_IMAGE
- IMAGE_NO — NUMBER
- HISTORY_NO — NUMBER — NOT NULL
- HISTORY_IMAGE_NAME — VARCHAR2(300) — NOT NULL
- HISTORY_IMAGE_ORDER — NUMBER — NOT NULL
TB_PRODUCT
- PRODUCT_ID — NUMBER
- PRODUCT_NAME — VARCHAR2(255) — NOT NULL
- PRODUCT_CATEGORY — VARCHAR2(50) — NOT NULL
- SHORT_DESCRIPTION — VARCHAR2(255) — NOT NULL
- DETAILED_DESCRIPTION — VARCHAR2(500)
- THUMBNAIL_IMAGE — VARCHAR2(255) — NOT NULL
- CREATED_DATE — DATE
TB_PRODUCT_IMAGES
- IMAGE_ID — VARCHAR2(20) — NOT NULL
- IMAGE_URL — VARCHAR2(300) — NOT NULL
- DISPLAY_ORDER — NUMBER
- PRODUCT_ID — NUMBER — Foreign key → TB_PRODUCT.PRODUCT_ID
TB_SETUP_HISTORY
- HISTORY_NO — NUMBER
- STORE_NAME — VARCHAR2(200) — NOT NULL
- STORE_ADDRESS — VARCHAR2(400) — NOT NULL
- MODEL_NAME — VARCHAR2(50) — NOT NULL
- HISTORY_CONTENT — VARCHAR2(1000) — NOT NULL
- HISTORY_DATE — DATE
- USER_ID — VARCHAR2(100) — NOT NULL
USERS
- USER_CD — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(20 BYTE)
- PASSWORD — VARCHAR2(255 BYTE)
- EMAIL — VARCHAR2(50 BYTE)
- PHONE_NO — VARCHAR2(15 CHAR)
- NAME — VARCHAR2(50 BYTE)
- JOIN_DT — DATE — NOT NULL
- USER_ST — CHAR(1 BYTE) — NOT NULL
- SOCIAL_USER — CHAR(1 BYTE) — NOT NULL
- AD_AGREED — CHAR(1 BYTE) — NOT NULL
- USER_ROLE — VARCHAR2(20 BYTE) — NOT NULL
USER_SOCIAL
- PROVIDER — VARCHAR2(20 BYTE) — NOT NULL
- USER_ID — VARCHAR2(20 BYTE) — Foreign key → USERS.USER_ID — NOT NULL
- PROVIDER_USER_ID — VARCHAR2(50 BYTE) — NOT NULL