Odeuk

Tables (5)

BUY (구매)

  • RID (일련번호) — INT — Primary key — NOT NULL
  • SELLER (판매자) — INT
  • SELL_TYPE (판매구분) — INT
  • SELL_NM (판매명) — VARCHAR(1000)
  • SELL_URL (판매URL) — VARCHAR(2000)
  • TOT_AMT (총금액) — INT
  • GOODS_AMT (물품금액) — INT
  • DELIVER_AMT (배송금액) — INT
  • DELIVER_TYPE (배송방법) — INT
  • DDING (띵여부) — BIT
  • GOODS_LIST (구매상품목록) — VARCHAR(2000)
  • REMARK (비고) — VARCHAR(2000)
  • INSERT_DT (생성일시) — DATETIME
  • UPDATE_DT (수정일시) — DATETIME
  • Field

CODE (코드마스터)

  • RID (일련번호) — INT — Primary key — NOT NULL
  • PRID (부모일련번호) — INT
  • CNAME (코드명) — VARCHAR(100)
  • ORDERBY (정렬순서) — INT
  • REMARK (비고) — VARCHAR(2000)
  • INSERT_DT (생성일시) — DATETIME
  • UPDATE_DT (수정일시) — DATETIME
  • Field

DEPOSIT (입금)

  • RID (일련번호) — INT — Primary key — NOT NULL
  • IN_DATE (입금일자) — DATE
  • IN_AMT (입금금액) — INT
  • REMARK (비고) — VARCHAR(2000)
  • INSERT_DT (생성일시) — DATETIME
  • UPDATE_DT (수정일시) — DATETIME
  • Field

GOODS (구매상품)

  • RID (일련번호) — INT — Primary key — NOT NULL
  • BUY (구매) — INT
  • GOODS_NM (상품명) — VARCHAR(200)
  • QTY (수량) — INT
  • GOODS_TYPE (물품구분) — INT
  • REMARK (비고) — VARCHAR(2000)
  • INSERT_DT (생성일시) — DATETIME
  • UPDATE_DT (수정일시) — DATETIME
  • Field

SELLER (판매자)

  • RID (일련번호) — INT — Primary key — NOT NULL
  • SELLER_NM (판매자명) — VARCHAR(100) — NOT NULL
  • SURL (홈페이지) — VARCHAR(2000)
  • REMARK (비고) — VARCHAR(2000)
  • INSERT_DT (생성일시) — DATETIME
  • UPDATE_DT (수정일시) — DATETIME
  • Field