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