Library

Tables (8)

Member (회원)

  • member_id (PK) — BIGINT — Primary key — NOT NULL
  • member_name (회원명) — VARCHAR
  • member_phone (회원 전화번호) — ENUM
  • member_reg_date (회원 등록일) — VARCHAR
  • library_type (회원 상태 (활동, 정지, 기타사유)) — VARCHAR
  • overdue_limit_date (대출 금지 날짜) — TIMESTAMP

librarian (사서)

  • librarian_id (PK) — BIGINT — Primary key — NOT NULL
  • library_id (PK2) — BIGINT — Foreign key → library.library_id — NOT NULL
  • library_id (FK) — VARCHAR
  • librarian_name (사서명) — ENUM
  • librarian_email (사서 메일) — VARCHAR
  • librarian_reg_date (사서 입사일) — VARCHAR

library (도서관)

  • library_id (PK) — BIGINT — Primary key — NOT NULL
  • library_name (도서관명) — VARCHAR
  • library_status (도서관 상태) — ENUM
  • library_info (도서관 설명) — VARCHAR
  • library_type (도서관 타입(공공,사립)) — VARCHAR

library_data (도서자료)

  • library_data_id (PK) — BIGINT — Primary key — NOT NULL
  • library_id (PK2) — BIGINT — Foreign key → library.library_id — NOT NULL
  • publisher_id (FK2) — VARCHAR
  • title (자료명) — VARCHAR
  • author (저자) — VARCHAR
  • data_status (대출상태(대출가능,대출중,기타)) — ENUM

library_program (도서관 프로그램)

  • library_program_id (PK) — BIGINT — Primary key — NOT NULL
  • library_id (PK2) — BIGINT — Foreign key → library.library_id — NOT NULL
  • program_name (프로그램명) — VARCHAR
  • program_instructor (진행자명) — VARCHAR
  • max_people (프로그램 정원) — INTEGER
  • start_date (프로그램 시작일) — DATE
  • end_date (프로그램 종료일) — 생략

library_program_apply (도서관 프로그램 신청)

  • apply_id (PK) — BIGINT — Primary key — NOT NULL
  • library_program_id (PK2) — BIGINT — Foreign key → library_program.library_program_id — NOT NULL
  • library_id (PK22) — BIGINT — Foreign key → library_program.library_id — NOT NULL
  • member_id (PK3) — BIGINT — Foreign key → Member.member_id — NOT NULL
  • apply_status (신청상태) — VARCHAR
  • apply_date (신청일) — date

library_publisher (출판사)

  • publisher_id (PK) — BIGINT — Primary key — NOT NULL
  • library_data_id (PK2) — BIGINT — Foreign key → library_data.library_data_id — NOT NULL
  • library_id (PK22) — BIGINT — Foreign key → library_data.library_id — NOT NULL
  • publisher_name (출판사명) — ENUM
  • publisher_tel (출판사번호) — VARCHAR

library_rental (대출관리)

  • library_rental_id (PK) — BIGINT — Primary key — NOT NULL
  • library_data_id (PK2) — BIGINT — Foreign key → library_data.library_data_id — NOT NULL
  • member_id (PK3) — BIGINT — Foreign key → Member.member_id — NOT NULL
  • library_id (PK22) — BIGINT — Foreign key → library_data.library_id — NOT NULL
  • rental_date (대출일) — TIMESTAMP
  • return_deadline (반남예정일) — VARCHAR
  • actual_return_date (반납일) — VARCHAR
  • overdue_status (연체상태) — TIMESTAMP