Uhdc-hack

hack erd

Tables (10)

Copy Of Copy Of content (nose)

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

Copy Of content (pet)

  • id — bigint(20) — Primary key — NOT NULL
  • id (create_user_id) — bigint(20) — Foreign key → user.id — NOT NULL
  • id (nose_id) — bigint(20) — Foreign key → Copy Of Copy Of content.id — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • text (name) — varchar(255) — NOT NULL
  • Field (register_date) — datetime — NOT NULL
  • text_type (birthday) — datetime — NOT NULL
  • type (gender) — varchar(1) — NOT NULL
  • vote_count (species) — varchar(255)
  • Field (weight) — varchar(255)
  • Field (gpt_text) — text
  • Field (neutered) — varchar(1)
  • Field (vaccination) — varchar(1)
  • Field (beauty) — varchar(1)
  • Field (significant) — text
  • Field (euthanasia_due_date) — datetime
  • Field (adoption) — int(11) — NOT NULL

change_log

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • content_id — bigint(20) — Foreign key → content.id
  • 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
  • id (create_user_id) — bigint(20) — Foreign key → user.id — NOT NULL
  • id (pet_id) — bigint(20) — Foreign key → Copy Of content.id — NOT NULL
  • date_created — datetime — NOT NULL
  • last_updated — datetime — NOT NULL
  • text (title) — varchar(255) — NOT NULL
  • text_type (text) — text — NOT NULL
  • Field (pet_image) — bigint(20) — NOT NULL
  • Field (instargram_link) — varchar(255)

content_file

  • content_files_id — bigint(20) — Foreign key → content.id
  • file_id — bigint(20) — Foreign key → file.id

file (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
  • width (type) — varchar(255) — NOT NULL

logged_in

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

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
  • Field (email) — varchar(255) — NOT NULL
  • Field (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