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)