fsdf

Tables (5)

book

  • book_id — INT — Primary key — NOT NULL
  • book_title — VARCHAR(50) — NOT NULL
  • book_author — VARCHAR(30) — NOT NULL
  • book_stock — SAMLLINT — NOT NULL
  • book_publisher — VARCHAR(20)
  • book_price — INT — NOT NULL

customer

  • customer_id — varchar(20) — Primary key — NOT NULL
  • customer_password — varchar(20) — NOT NULL
  • customer_last_name — varchar(2) — NOT NULL
  • customer_first_name — varchar(3) — NOT NULL
  • customer_road_name — varchar(20) — NOT NULL
  • customer_detail_address — varchar(10)
  • customer_postal_code — tinyint — NOT NULL

order

  • order_number — INT — Primary key — NOT NULL
  • customer_id — VARCHAR(20) — NOT NULL
  • order_date — DATE — NOT NULL
  • order_total — INT — NOT NULL

order_detail

  • order_detail_id — INT — Primary key — NOT NULL
  • order_number — INT — NOT NULL
  • book_id — INT — NOT NULL
  • order_date — SMALLINT — NOT NULL

refund

  • refund_number — INT — Primary key — NOT NULL
  • order_number — INT — NOT NULL
  • refund_process — varchar(10) — NOT NULL
  • refund_date — DATE — NOT NULL
  • refund_reason — VARCHAR(50) — NOT NULL