35-sopt-server-homework

Tables (3)

Category (category)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)

ShoppingCategory (store_category)

  • id — BIGINT — Primary key — NOT NULL
  • main_category_id — BIGINT — Foreign key → Category.id — NOT NULL
  • name — VARCHAR(255)

FoodCategory (food_category)

  • id — BIGINT — Primary key — NOT NULL
  • main_category_id — BIGINT — Foreign key → Category.id — NOT NULL
  • name — VARCHAR(255)