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