개쇼
개쇼
테이블 (11)
ADMIN
- ADMIN_ID — VARCHAR(100) — 기본 키 — NOT NULL — NOT NULL
- ADMIN_PWD — VARCHAR(100)
- ADMIN_EMAIL_ADDR — VARCHAR(100)
- ADMIN_EMAIL_PWD — VARCHAR(1000)
- ADMIN_SHOP_TEL — VARCHAR(100)
- ADMIN_ACCOUNT — VARCHAR(200)
- ADMIN_OPENDATE — DATE
BOARD_QA
- QA_SEQ — INT — 기본 키 — NOT NULL
- PRODUCTID — VARCHAR(100)
- USER_ID — VARCHAR(50)
- QA_PWD — VARCHAR(100)
- QA_SUBJECT — VARCHAR(50)
- QA_CONTENT — VARCHAR(4000)
- QA_STATE — INT
- QA_REPLY — INT
- QA_LOGTIME — DATE
DELIVERY
- DELIVERY_CODE — INT — 기본 키 — NOT NULL
- DELIVERY_TYPE — VARCHAR(100)
- DELIVERY_FEE — INT
DELIVERY_ADDITIONAL
- ZIPCODE — VARCHAR(100)
- ADDRESS — VARCHAR(500)
EVENT
- EVENT_NO — INT — 기본 키 — NOT NULL — NOT
- EVENT_NAME — VARCHAR(300)
- EVENT_IMAGE — VARCHAR(100)
- EVENT_URL — VARCHAR(1000)
- EVENT_STARTDATE — DATE
- EVENT_ENDDATE — DATE
LIKETABLE
- SEQ — INT — 기본 키 — NOT NULL
- PRODUCT_NO — INT
- USERID — VARCHAR(100)
MEMBER
- SEQ — INT — 기본 키 — NOT NULL
- STATE — INT
- NAME — VARCHAR(30) — NOT NULL
- ID — VARCHAR(100) — NOT NULL
- PWD — VARCHAR(100) — NOT NULL
- EMAIL1 — VARCHAR(30)
- EMAIL2 — VARCHAR(30)
- TEL1 — VARCHAR((10)
- TEL2 — VARCHAR(10)
- TEL3 — VARCHAR((10)
- ZIPCODE — VARCHAR(20)
- ADDR1 — VARCHAR(100)
- ADDR2 — VARCHAR(100)
- POINT — INT
- REGISTERDATE — DATE
- SESSIONID — VARCHAR(50)
- SESSIONLIMIT — TIMESTAMP
PAYMENT
- PAYMENT_AMOUNT — INT
- ORDER_NO — INT
- PAYMENT_METHOD — INT
- PAYMENT_DATE — DATE
- PAYMENT_STATE — VARCHAR(200)
PRODUCT_CATEGORY
- PRODUCT_CATEGORY — INT — 기본 키 — NOT NULL
- PRODUCT_CATEGORY_NAME — VARCHAR(50)
QAMESSAGE
- SEQ — INT — 기본 키 — NOT NULL
- SENDER — VARCHAR(20)
- SENDADDR — VARCHAR(30)
- SUBJECT — VARCHAR(50)
- CONTENT — VARCHAR(2000)
- SENDDATE — DATE
Untitled
- SALES_SEQ — INT — 기본 키 — NOT NULL
- ORDER_NO — INT
- ORDER_ID — VARCHAR(100)
- SALES_REVENUE — INT
- SALES_PAYMENT_JSON — VARCHAR(2000)
- SALES_DATE — DATE