Bodeum

Tables (4)

dogs

  • dog_id — int — Primary key — NOT NULL
  • owner_id — int — Foreign key → owner.owner_id — NOT NULL
  • dog_name — VARCHAR(50) — NOT NULL
  • dog_sex — int — NOT NULL
  • Field3

owner

  • owner_id — int — Primary key — NOT NULL
  • owner_name — VARCHAR[50] — NOT NULL
  • owner_sex — int — NOT NULL
  • owner_habit — VARCHAR[50]
  • environment (enviroment) — int

project_list (project)

  • project_id — int — Primary key — NOT NULL
  • project_name — VARCHAR[50] — NOT NULL
  • project_type — VARCHAR[50] — NOT NULL
  • project_price — int — NOT NULL
  • project_date — Date
  • trainer_id — int
  • place_id — int

trainer

  • trainer_id — int — Primary key — NOT NULL
  • Field
  • Field2