lib
Tables (5)
book (책)
- b_id (Key) — Primary key — NOT NULL
- b_name (이름)
- b_publisher (출판사)
- b_price (가격)
entry (등록정보)
- e_num (Key) — Primary key — NOT NULL
- s_id (Key2) — Foreign key → staff.s_id — NOT NULL
- b_id (Key3) — Foreign key → book.b_id — NOT NULL
- insertday (등록일)
- updateday (수정일)
- deleteday (삭제일)
- etc (비고, 사유)
orders (주문정보)
- o_num (num) — Primary key — NOT NULL
- startdate (대여일)
- b_id (Key2) — Foreign key → book.b_id — NOT NULL
- p_id (Key3) — Foreign key → people.p_id — NOT NULL
- enddate (반납일)
- overdate (연장)
people (사람들)
- p_id (Key) — Primary key — NOT NULL
- p_name (이름)
- p_phone (Field2)
- p_email (Field3)
staff (직원)
- s_id (Key) — Primary key — NOT NULL
- s_name (이름)
- s_rank (직급)
- s_startdate (입사일)
- s_enddate (퇴사일)