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