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 }