asdf
Tables (16)
authors
- author_id — NUMBER(10) — Primary key — NOT NULL
- name — VARCHAR2(100 CHAR) — NOT NULL
- bio — CLOB
books
- book_id — NUMBER(10) — Primary key — NOT NULL
- title — VARCHAR2(255 CHAR) — NOT NULL
- author_id — NUMBER(10) — Foreign key → authors.author_id
- publisher_id — NUMBER(10) — Foreign key → publishers.publisher_id
- price — NUMBER(10, 2) — NOT NULL
- stock — NUMBER(10)
- category_id — NUMBER(10) — Foreign key → categories.category_id
- published_at — DATE
categories
- category_id — NUMBER(10) — Primary key — NOT NULL
- category_name — VARCHAR2(100 CHAR) — NOT NULL
coupons
- coupon_id — NUMBER(10) — Primary key — NOT NULL
- code — VARCHAR2(50 CHAR) — NOT NULL
- discount — NUMBER(5, 2) — NOT NULL
- expiry_date — DATE — NOT NULL
ebook_purchases
- purchase_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → users.user_id
- ebook_id — NUMBER(10) — Foreign key → ebooks.ebook_id
- purchase_date — TIMESTAMP(0)
ebooks
- ebook_id — NUMBER(10) — Primary key — NOT NULL
- book_id — NUMBER(10) — Foreign key → books.book_id
- file_url — VARCHAR2(255 CHAR) — NOT NULL
memberships
- membership_id — NUMBER(10) — Primary key — NOT NULL
- membership_name — VARCHAR2(50 CHAR) — NOT NULL
- discount_rate — NUMBER(5, 2) — NOT NULL
- min_points — NUMBER(10) — NOT NULL
order_items
- order_item_id — NUMBER(10) — Primary key — NOT NULL
- order_id — NUMBER(10) — Foreign key → orders.order_id
- book_id — NUMBER(10) — Foreign key → books.book_id
- quantity — NUMBER(10) — NOT NULL
- price — NUMBER(10, 2) — NOT NULL
orders
- order_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → users.user_id
- total_price — NUMBER(10, 2) — NOT NULL
- status — VARCHAR2(30 BYTE)
- order_date — TIMESTAMP(0)
points
- point_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → users.user_id
- points — NUMBER(10) — NOT NULL
- reason — CLOB
- created_at — TIMESTAMP(0)
publishers
- publisher_id — NUMBER(10) — Primary key — NOT NULL
- name — VARCHAR2(100 CHAR) — NOT NULL
- address — CLOB
reviews
- review_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → users.user_id
- book_id — NUMBER(10) — Foreign key → books.book_id
- rating — NUMBER(10)
- comment — CLOB
- created_at — TIMESTAMP(0)
ticket_orders
- ticket_order_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → users.user_id
- ticket_id — NUMBER(10) — Foreign key → tickets.ticket_id
- quantity — NUMBER(10) — NOT NULL
- total_price — NUMBER(10, 2) — NOT NULL
- order_date — TIMESTAMP(0)
tickets
- ticket_id — NUMBER(10) — Primary key — NOT NULL
- event_name — VARCHAR2(255 CHAR) — NOT NULL
- location — VARCHAR2(255 CHAR) — NOT NULL
- event_date — TIMESTAMP(0) — NOT NULL
- price — NUMBER(10, 2) — NOT NULL
- total_seats — NUMBER(10) — NOT NULL
- available_seats — NUMBER(10) — NOT NULL
used_books
- used_book_id — NUMBER(10) — Primary key — NOT NULL
- seller_id — NUMBER(10) — Foreign key → users.user_id
- book_id — NUMBER(10) — Foreign key → books.book_id
- price — NUMBER(10, 2) — NOT NULL
- condition — VARCHAR2(30 BYTE) — NOT NULL
- status — VARCHAR2(30 BYTE)
users
- user_id — NUMBER(10) — Primary key — NOT NULL
- username — VARCHAR2(50 CHAR) — NOT NULL
- password_hash — VARCHAR2(255 CHAR) — NOT NULL
- email — VARCHAR2(100 CHAR) — NOT NULL
- phone — VARCHAR2(20 CHAR)
- address — CLOB
- membership_id — NUMBER(10) — Foreign key → memberships.membership_id
- points — NUMBER(10)
- created_at — TIMESTAMP(0)