product_option_test

Tables (3)

product

  • product_id — number — Primary key — NOT NULL
  • product_name — varchar2(100)

product_main_option

  • product_main_option_id — number — Primary key — NOT NULL
  • parent_product_main_option_id — number — Foreign key → product_main_option.product_main_option_id — NOT NULL
  • product_main_option_name — varchar2(100)

product_option

  • product_option_id — number — Primary key — NOT NULL
  • product_main_option_id — number — Foreign key → product_main_option.product_main_option_id — NOT NULL
  • product_id — number — Foreign key → product.product_id — NOT NULL
  • price — number