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