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)