uhdc-hack

Tables (10)

change_log

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • content_id — bigint(20)
  • date_created — datetime — NOT NULL
  • patch — longtext — NOT NULL
  • revision — int(11) — NOT NULL
  • type — varchar(255) — NOT NULL

content

  • id — bigint(20) — Primary key — NOT NULL
  • create_user_id — bigint(20) — NOT NULL
  • pet_id — bigint(20) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • title — varchar(255) — NOT NULL
  • text — text — NOT NULL
  • pet_image — bigint(20) — NOT NULL
  • instargram_link — varchar(255)

content_file

  • content_files_id — bigint(20)
  • file_id — bigint(20)

image_file

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • attach_type — varchar(255) — NOT NULL
  • byte_size — int(11) — NOT NULL
  • name — varchar(255) — NOT NULL
  • org_name — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL

logged_in

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • version — bigint(20) — NOT NULL
  • date_created — datetime — NOT NULL
  • remote_addr — varchar(255)

nose

  • id — bigint(20) — Primary key — NOT NULL
  • nose_vector — varchar(255) — NOT NULL
  • description — text — NOT NULL
  • date_created — datetime — NOT NULL

pet

  • id — bigint(20) — Primary key — NOT NULL
  • create_user_id — bigint(20) — NOT NULL
  • nose_id — bigint(20) — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • name — varchar(255) — NOT NULL
  • register_date — datetime — NOT NULL
  • birthday — datetime — NOT NULL
  • gender — varchar(1) — NOT NULL
  • species — varchar(255)
  • weight — varchar(255)
  • gpt_text — text
  • neutered — varchar(1)
  • vaccination — varchar(1)
  • beauty — varchar(1)
  • significant — text
  • euthanasia_due_date — datetime
  • adoption — int(11) — NOT NULL

role

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • authority — varchar(255) — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • username — varchar(15) — NOT NULL
  • password — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • sns_link — varchar(255)
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL

user_role

  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • role_id — bigint(20) — Foreign key → role.id — NOT NULL