Oh-Jo-Go_Library_ERD
Tables (11)
Admin (admin_tbl)
- 관리자아이디 (A_ID) — BIGINT — Primary key — NOT NULL
- 유저아이디 (U_ID) — BIGINT — Foreign key → User.유저아이디 — NOT NULL
- 역할아이디 (R_ID) — BIGINT — Foreign key → Role.역할아이디 — NOT NULL
Book (book_tbl)
- 책아이디 (B_ID) — BIGINT — Primary key — NOT NULL
- 책위치아이디 (B_LOC_ID2) — BIGINT — Foreign key → Book_Loc.책위치아이디 — NOT NULL
- 책바코드아이디 (B_BC_ID2) — BIGINT — Foreign key → Book_Barcode.책바코드아이디 — NOT NULL
- 책아이디 (B_ID2) — BIGINT — Foreign key → Book_Barcode.책아이디 — NOT NULL
- 책제목 (B_TITLE) — VARCHAR
- 책저자 (B_AUTHOR) — VARCHAR
- 책출판사 (B_PUBLISHER) — VARCHAR
- 책출판년도 (B_PUB_YEAR) — BIGINT
- 책청구기호 (B_CALL_NUM) — VARCHAR
- 책상태 (B_STATUS) — ENUM — ENUM { AVAILABLE, RENTED, LOST }
Book_Barcode (book_barcode_tbl)
- 책바코드아이디 (B_BC_ID) — BIGINT — Primary key — NOT NULL
- 책아이디 (B_ID) — BIGINT — Foreign key → Book.책아이디 — NOT NULL
- 책바코드 (B_BC_CODE) — VARCHAR
Book_Class (book_class_tbl)
- 책상위장르아이디 (B_CL_PARENT_ID) — BIGINT — Primary key — NOT NULL
Book_Genre (book_genre_tbl)
- 책장르아이디 (B_GR_ID) — BIGINT — Primary key — NOT NULL
- 책상위장르아이디 (B_CL_PARENT_ID) — BIGINT — Foreign key → Book_Class.책상위장르아이디 — NOT NULL
- 책장르이름 (B_GR_NAME) — ENUM — ENUM{ NOVEL, HISTORY,,,etc }
Book_Info (book_info_tbl)
- 책정보아이디 (B_IN_ID) — BIGINT — Primary key — NOT NULL
- 책아이디 (B_ID) — BIGINT — Foreign key → Book.책아이디 — NOT NULL
- 책장르아이디 (B_GR_PARENT_ID) — BIGINT — Foreign key → Book_Genre.책상위장르아이디 — NOT NULL
- 책아이디 (B_ID2) — BIGINT — Foreign key → Book.책아이디 — NOT NULL
- 책요약 (B_IN_SUM) — TEXT
- 책이미지 (B_IN_IMG_URL) — VARCHAR
Book_Loc (book_location_tbl)
- 책위치아이디 (B_LOC_ID) — BIGINT — Primary key — NOT NULL
- 책선반코드 (B_SHELF_CODE) — VARCHAR
Notification (notification_tbl)
- 알림아이디 (N_ID) — BIGINT — Primary key — NOT NULL
- 유저아이디 (U_ID) — BIGINT — Foreign key → User.유저아이디 — NOT NULL
- 알림유형 (N_TYPE) — ENUM — ENUM{ EMAIL, PUSH, SMS }
- 알림메세지 (N_MESSAGE) — VARCHAR
- 알림일자 (N_SENT_AT) — DATETIME
Rent (rent_tbl)
- 대여아이디 (R_ID) — BIGINT — Primary key — NOT NULL
- 유저아이디 (U_ID) — BIGINT — Foreign key → User.유저아이디 — NOT NULL
- 책아이디 (B_ID) — BIGINT — Foreign key → Book.책아이디 — NOT NULL
- 책대여일 (R_DATE) — DATETIME
- 책반납일 (R_RETRUN_DATE) — DATETIME
- 대여상태 (R_STATUS) — ENUM — ENUM{ RENTED, RETURNED, OVERDUE }
Role (role_tbl)
- 역할아이디 (R_ID) — BIGINT — Primary key — NOT NULL
- 역할이름 (R_NAME) — ENUM — ENUM{ SUPER, STAFF }
User (user_tbl)
- 유저아이디 (U_ID) — BIGINT — Primary key — NOT NULL
- 비밀번호 (U_PW) — VARCHAR(16)
- 유저이름 (U_NAME) — VARCHAR — 외대 연동 비밀번호
- 이메일 (U_EMAIL) — VARCHAR
- 전화번호 (U_TEL) — VARCHAR
- 가입일자 (U_JOIN_AT) — VARCHAR
- 상태 (U_STATUS) — ENUM — ENUM { ACTIVE, INACTIVE, DELETED }