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)