bookRentalShop

Tables (12)

AUTHOR (작가 코드)

  • A_ID (Key) — Primary key — NOT NULL
  • A_NAME (Field2)
  • A_GENDER (Field3)

BILL (지불 묶음)

  • BILL_ID (Key) — Primary key — NOT NULL
  • M_ID (Field)
  • AMOUNT (Field2)
  • CASH (Field3)
  • PAY_POINT (Field4)
  • ACC_POINT (Field5)
  • BILL_DATE (Field6)

BOOK (전체도서명세)

  • ISBN (Key) — Primary key — NOT NULL
  • B_TITLE (Field2)
  • A_ID (Field3)
  • P_ID (Field4)
  • GENRE (Field5)
  • A_ID (Key2) — Foreign key → AUTHOR.A_ID — NOT NULL
  • P_ID (Key3) — Foreign key → PUBLISHER.P_ID — NOT NULL

MEMBER (멤버)

  • M_ID (Key) — CHAR(5) — Primary key — NOT NULL
  • M_NAME (Field)
  • M_ADDR (Field2)
  • M_BIRTH (Field3)
  • M_TEL (Field4)
  • M_POINT (Field5)
  • M_GRADE (Field7)
  • M_SIGN_UP_DATE (Field6)

PAYMENT (지불)

  • PAY_ID (Key) — Primary key — NOT NULL
  • M_ID (Field5)
  • AMOUNT (Field3)
  • PAY_DATE (Field4)
  • RT_ID (Key2) — Foreign key → RENTAL.RT_ID — NOT NULL
  • RS_ID (Key3) — Foreign key → RESTORE.RS_ID — NOT NULL
  • BILL_ID (Key4) — Foreign key → BILL.BILL_ID — NOT NULL

PUBLISHER (출판사 코드)

  • P_ID (Key) — Primary key — NOT NULL
  • P_VAL (Field2)
  • P_ADDR (Field3)
  • P_TEL (Field)

RENTAL (대여)

  • RT_ID (Key) — CHAR(6) — Primary key — NOT NULL
  • RT_DATE (Field3) — CHAR(5)
  • RS_D_DATE (Field4) — CHAR(5)
  • AMOUNT (Field5) — INTEGER
  • M_ID (Key2) — CHAR(5) — Foreign key → MEMBER.M_ID — NOT NULL
  • B_ID (Key3) — CHAR(5) — Foreign key → STORE.B_ID — NOT NULL

RESTORE (반납)

  • RS_ID (Key) — Primary key — NOT NULL
  • RS_DATE (Field2)
  • RS_D_DATE (Field3)
  • AMOUNT (Field4)
  • M_ID (Key2) — Foreign key → MEMBER.M_ID — NOT NULL
  • B_ID (Key3) — Foreign key → STORE.B_ID — NOT NULL

RS_BOOK (대여점도서명세)

  • ISBN (Key) — Primary key — NOT NULL
  • B_TITLE (Field2)
  • GENRE (Field5)
  • EXP1 (Field)
  • EXP2 (Field6)
  • A_ID (Key2) — Foreign key → AUTHOR.A_ID — NOT NULL
  • P_ID (Key3) — Foreign key → PUBLISHER.P_ID — NOT NULL

STORE (대여점도서보유현황)

  • B_ID (Key) — Primary key — NOT NULL
  • PRICE (Field3)
  • V_ID (Field4)
  • S_DATE (Field5)
  • RENTAL_FEE (Field)
  • B_ID (Key2) — Foreign key → VB_LIST.VB_ID — NOT NULL
  • ISBN (Key3) — Foreign key → RS_BOOK.ISBN — NOT NULL

VB_LIST (출판사의 도서목록)

  • VB_ID (Key) — Primary key — NOT NULL
  • ISBN (Field2)
  • PRICE (Field3)
  • V_ID (Field4)
  • V_ID (Key2) — Foreign key → VENDOR.V_ID — NOT NULL

VENDOR (출판사)

  • V_ID (Key) — Primary key — NOT NULL
  • V_NAME (Field2)
  • V_TEL (Field3)