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