8TB-Project

Tables (8)

Book (Untitled)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (title) — VARCHAR — NOT NULL
  • Field (author) — VARCHAR — NOT NULL
  • Field (category) — VARCHAR — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (isbn) — BINARY — NOT NULL

Book_Item (CopyOfUntitled)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (book_id) — BIGINT — Foreign key → Book.Key — NOT NULL
  • Field (serial_number) — BINARY — NOT NULL

Rent_Month_Counts (Untitled8)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (book_id) — BIGINT — Foreign key → Book.Key — NOT NULL
  • Field (count) — BINARY — NOT NULL
  • Field (bundle_at) — TIMESTAMP — NOT NULL

Rental (Untitled7)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (book_item_id) — BIGINT — Foreign key → Book_Item.Key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
  • Field (status) — ENUM — NOT NULL — 대여/반납
  • Field (rental_date) — TIMESTAMP — NOT NULL
  • Field (return_date) — TIMESTAMP — NOT NULL
  • Field (due_date) — DATE — NOT NULL

Reservation (Untitled5)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (book_id) — BIGINT — Foreign key → Book.Key — NOT NULL
  • Field (status) — ENUM — NOT NULL
  • Field (priority) — BINARY — NOT NULL
  • Field (rent_timeout) — TIMESTAMP
  • Field (created_at) — TIMESTAMP — NOT NULL

Review (Untitled6)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (book_id) — BIGINT — Foreign key → Book.Key — NOT NULL
  • Field (content) — VARCHAR — NOT NULL
  • Field (rating) — TINYINT — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (deleted_at) — TIMESTAMP — NOT NULL

Search_Keyword (Untitled4)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (keyword) — VARCHAR — NOT NULL
  • Field (count) — BINARY — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL

User (Untitled2)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (email) — VARCHAR — NOT NULL
  • Field (password) — VARCHAR — NOT NULL
  • Field (nickname) — VARCHAR — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (deleted_at) — TIMESTAMP — NOT NULL
  • Field (user_role) — ENUM — NOT NULL