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