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)