개쇼

개쇼

테이블 (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