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