Legacy_Shop

Tables (4)

file_tbl (CopyOfUntitled)

  • fileId (Key) — BIGINT — Primary key — NOT NULL
  • refType (Field) — VARCHAR
  • refId (Field2) — VARCHAR
  • uploadType (Field3) — VARCHAR
  • fileName (Field4) — VARCHAR
  • filePath (Field5) — VARCHAR
  • fileUrl (Field6) — DATETIME
  • uploadStatus (Field7) — VARCHAR
  • delYn (Field8) — CHAR
  • crtDt (Field9) — DATETIME
  • updDt (Field10) — DATETIME
  • delDt (Field11) — DATETIME

order_cart (Untitled)

  • cartNo (Key) — BIGINT — Primary key — NOT NULL
  • userId (Field) — VARCHAR
  • prodNo (Field2) — VARCHAR
  • qty (Field3) — INT
  • crtDt (Field4) — DATETIME
  • uptDt (Field5) — DATETIME
  • delDt (Field6) — DATETIME
  • delYn (Field7) — CHAR(1)

order_detail (Untitled2)

  • orderDetailNo (Key) — BIGINT — Primary key — NOT NULL
  • orderNo (Field) — VARCHAR
  • prodNo (Field3) — VARCHAR
  • qty (Field2) — INT
  • price (Field4) — INT
  • delYn (Field5) — CHAR
  • crtDt (Field6) — DATETIME
  • udtDt (Field7) — DATETIME
  • delDt (Field8) — DATETIME

order_master (주문 사용자)

  • ordNo (NOT NULL) — VARCHAR — Primary key — NOT NULL
  • userId (Field) — VARCHAR
  • orderDate (Field4) — DATETIME
  • orderStatus (Field3) — VARCHAR
  • TotalAmount (Field7) — INT
  • crtDt (Field2) — DATETIME
  • updDt (Field5) — DATETIME
  • delDt (Field6) — DATETIME