managingBookProgram
Tables (9)
MRPBOOK (마스터테이블_책)
- bookcode (도서코드) — nvarchar(50) — Primary key — NOT NULL
- bookname (도서이름) — nvarchar(50)
- bookprice (도서가격) — int
- bookyears (책보증기간) — int
MRPCUST (마스터테이블_거래처)
- custcode (거래처코드) — nvarchar(20) — Primary key — NOT NULL
- custname (거래처이름) — nvarchar(20)
- custadress (거래처주소) — nvarchar(50)
MRPLEND (대여테이블)
- lendcode (대여코드) — int — Primary key — NOT NULL
- lenddate (대여일자) — date
- expectdate (반납예정일자) — date
- userinfo (대여회원) — nvarchar(20)
MRPLEND_DETAIL (대여디테일)
- lendbcode (대여디테일코드) — int — Primary key — NOT NULL
- lendcode (대여코드) — int — Foreign key → MRPLEND.lendcode — NOT NULL
- barcode (도서바코드) — Bigint — Foreign key → MRPREGI_DETAIL.barcode — NOT NULL
MRPORDER (발주테이블)
- ordercode (주문코드) — int — Primary key — NOT NULL
- custcode (거래처코드) — nvarchar(20) — Foreign key → MRPCUST.custcode — NOT NULL
- bookcode (책코드) — nvarchar(50) — Foreign key → MRPBOOK.bookcode — NOT NULL
- userid (구매 유저) — nvarchar(20) — Foreign key → MRPUSER.userid — NOT NULL
- bookpriceD (할인된책가격) — int
- totalprice (구매 총 가격) — int
- ordernum (구매 수량) — int
- orderdate (구매 날짜) — date
- orderstate (구매 상태) — nvarchar(20)
MRPREGI (입고테이블)
- regicode (입고코드) — int — Primary key — NOT NULL
- ordercode (주문코드) — int — Foreign key → MRPORDER.ordercode — NOT NULL
- reginum (입고갯수) — int
- regidate (입고날짜) — date
- registate (입고상태) — nvarchar(20)
- regiuser (입고유저) — nvarchar(30)
- custcode (거래처코드) — nvarchar(20)
- bookcode (도서코드) — join
- orderstate (구매 상태) — join
MRPREGI_DETAIL (등록디테일(재고))
- barcode (도서바코드) — Bigint — Primary key — NOT NULL
- regicode (입고코드) — int — Foreign key → MRPREGI.regicode — NOT NULL
- warranty (도서보증기간) — date
- confirmdate (등록날짜) — date
- useyn (대출상태) — nvarchar(5)
MRPRETURN (반납테이블)
- returncode (반납코드) — int — Primary key — NOT NULL
- lendbcode (대여디테일코드) — int — Foreign key → MRPLEND_DETAIL.lendbcode — NOT NULL
- returndate (반납일자) — date
MRPUSER (마스터테이블_회원)
- userid (유저코드) — int — Primary key — NOT NULL
- username (유저이름) — nvarchar(20)
- usergrade (유저등급) — nvarchar(20)
- useradress (유저주소) — nvarchar(50)