SchemaSpy Analysis of zooqini_checkin_dev - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  activities.aid	addresses.aid
  activities.eid	events.eid
  activity_members.aid	addresses.aid
  activity_types.aid	addresses.aid
  authority.id	rest_test.id
  barcode.id	rest_test.id
  business_images.bid	business.bid
  business_payment.bid	business.bid
  business_urls.bid	business.bid
  calendar_event.eid	events.eid
  event_frequency.eid	events.eid
  event_images.eid	events.eid
  events.gid	groups.gid
  fr_group_type.fid	franchises.fid
  fr_groups.fid	franchises.fid
  group_images.gid	groups.gid
  group_mapping.gid	groups.gid
  group_mapping.id	rest_test.id
  group_members.gid	groups.gid
  group_required.gid	groups.gid
  group_types.bid	business.bid
  group_waiver.gid	groups.gid
  milestones.id	milestones_rewards.id
  offline_checkin.bid	business.bid
  recess_tools_classes.id	rest_test.id
  recess_tools_packages.id	rest_test.id
  rewards.id	milestones_rewards.id
  sponser_logo.id	rest_test.id
  store_mapping.bid	business.bid
  store_mapping.id	rest_test.id
  user_follow.id	rest_test.id
  user_journals.aid	addresses.aid
  zip_code.id	milestones_rewards.id

  33 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  activity_members	0
  business_images	26
  business_payment	0
  event_images	2
  fr_groups	0
  group_members	133
  logs	37
  offline_checkin	14
  pd_reset_request	19
  signup	7
  store_mapping	8
  user_follow	0

  12 instances of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':
  Anomaly not detected

• Tables that contain a single column:

  Table	Column
  logs	prams

  1 instance of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  addresses

  1 instance of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected