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 (퇴사일)