0330 homework_13
Tables (4)
Convenience (convenience)
- Convenience id (convenience_id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR
Product field (product_field)
- Field id (field_id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR
Products (products)
- Product id (product_id) — BIGINT — Primary key — NOT NULL
- Field id (field_id) — BIGINT — Foreign key → Product field.Field id — NOT NULL
- Name (name) — VARCHAR
Products Interest (products_interest)
- Convenience id (convenience_id) — BIGINT — Foreign key → Convenience.Convenience id — NOT NULL
- Product id (product_id) — BIGINT — Foreign key → Products.Product id — NOT NULL