BookShop
Tables (7)
address (Untitled4)
- Key — Primary key — NOT NULL
book (Untitled)
- book_code (Key) — VARCHAR(50) — Primary key — NOT NULL
- book_title (Field) — VARCHAR(30)
- book_author (Field2) — VARCHAR(20)
- book_publisher (Field3) — VARCHAR(20)
- book_price (Field4) — INT(10)
- book_count (Field5) — INT(10)
- Field6
delivery (CopyOfUntitled3)
- delivery_code (Key) — VARCHAR(20) — Primary key — NOT NULL
- order_id (Key2) — VARCHAR(20) — Foreign key → orders.order_id — NOT NULL
- delivery_status (Field) — BOOLEAN(2)
- Field2
genre (Untitled3)
- genre_code (Key) — VARCHAR(20) — Primary key — NOT NULL
- book_code (Key2) — VARCHAR(50) — Foreign key → book.book_code — NOT NULL
orderBooks (Untitled5)
- order_book_id (Key) — VARCHAR(20) — Primary key — NOT NULL
- order_id (Key2) — VARCHAR(20) — Foreign key → orders.order_id — NOT NULL
- book_code (Key3) — VARCHAR(50) — Foreign key → book.book_code — NOT NULL
- Field
orders (Untitled2)
- order_id (Key) — VARCHAR(20) — Primary key — NOT NULL
- user_email (Key2) — VARCHAR(20) — Foreign key → user.user_email — NOT NULL
- Field
user (usertbl)
- user_email (Key) — VARCHAR(20) — Primary key — NOT NULL
- user_name (Field) — VARCHAR(10)
- user_phone (Field5) — VARCHAR(20)
- user_address (Field2) — ADDRESS