OMP
Tables (10)
book (Untitled)
- isbn (Key) — Primary key — NOT NULL
- book_name (Field)
- author (Field2)
- publisher (Field3)
- book_msg (Field4)
- book_img (Field5)
- category_id (Field6)
- time (Field7)
book_inven (Untitled2)
- id (Key) — Primary key — NOT NULL
- isbn (Key2) — Foreign key → book.isbn — NOT NULL
- store_id (Key3) — Foreign key → bookstore.store_id — NOT NULL
- book_name (Field2)
- inven (Field4)
bookstore (Untitled3)
- store_id (Key) — Primary key — NOT NULL
- store_name (Field)
- repre_name (Field2)
- address (Field3)
- store_msg (Field4)
- p_num (Field6)
- store_email (Field7)
- store_img (Field5)
favorite_bookstore (Untitled5)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.user_id — NOT NULL
- store_id (Key3) — Foreign key → bookstore.store_id — NOT NULL
- date (Field)
like_book (CopyOfUntitled5)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.user_id — NOT NULL
- isbn (Key3) — Foreign key → book.isbn — NOT NULL
- date (Field)
order_info (Untitled6)
- order_info_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.user_id — NOT NULL
- order_name (Field)
- order_address (Field2)
- order_p_num (Field3)
- order_email (Field4)
- order_memo (Field5)
- buy_date (Field6)
- payment (Field7)
- order_num (Field8)
order_products (CopyOfUntitled6)
- order_info_id (Key2) — Foreign key → order_info.order_info_id — NOT NULL
- isbn (Key22) — Foreign key → book_inven.isbn — NOT NULL
- store_id (Key32) — Foreign key → book_inven.store_id — NOT NULL
- Field
review (CopyOfCopyOfUntitled6)
- id (Key2) — Primary key — NOT NULL
- user_id (Key) — Foreign key → user.user_id — NOT NULL
- isbn (Key22) — Foreign key → book_inven.isbn — NOT NULL
- store_id (Key32) — Foreign key → book_inven.store_id — NOT NULL
- book_name (Field2)
- title (Field)
- content (Field3)
- evaluate_score (Field4)
- date (Field5)
shipping_info (Untitled7)
- id (Key2) — Primary key — NOT NULL
- store_id (Key) — Foreign key → bookstore.store_id — NOT NULL
- business_num (Field)
- bank (Field2)
- account (Field3)
- shipping_policy (Field4)
- send_address (Field5)
- return_address (Field6)
user (Untitled4)
- user_id (Key) — Primary key — NOT NULL
- password (Field)
- name (Field2)
- email (Field4)
- p_num (Field5)
- address (Field3)