eyedlab
Tables (21)
adoption_log
- id — INT — Primary key — NOT NULL
- animal_id — VARCHAR(45) — Foreign key → animal.id — NOT NULL
animal
- id — VARCHAR(45) — Primary key — NOT NULL
- bread_id — INT — Foreign key → breed.id — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.id — NOT NULL
- isRaisingInShelter — BOOLEAN
- user_id(기존필드사용) — VARCHAR(45) — NOT NULL
animal_image
- id — INT — Primary key — NOT NULL
- animal_id — VARCHAR(45) — Foreign key → animal.id — NOT NULL
- is_deleted — BOOLEAN
animal_notice
- id — INT — Primary key — NOT NULL
- animal_id — VARCHAR(45) — Foreign key → animal.id — NOT NULL
biz_user
- id — VARCHAR(45) — Primary key — NOT NULL
biz_user_file
- biz_user_info_id — INT — Foreign key → biz_user_info.biz_user_info_id — NOT NULL
biz_user_info
- biz_user_info_id — INT — Primary key — NOT NULL
- biz_user_id — VARCHAR(45) — Foreign key → biz_user.id — NOT NULL
breed
- id — INT — Primary key — NOT NULL
- name — VARCHAR(20)
iris
- id — VARCHAR(45) — Primary key — NOT NULL
iris_info
- animal_id — VARCHAR(45) — Foreign key → animal.id — NOT NULL
- iris_id — VARCHAR(45) — Foreign key → iris.id — NOT NULL
iris_registration_info
- id — INT — Primary key — NOT NULL
- animal_id — VARCHAR(45) — Foreign key → animal.id — NOT NULL
missing_report
- id — INT — Primary key — NOT NULL
- animal_id — VARCHAR(45) — Foreign key → animal.id — NOT NULL
payment_log
- user_id — VARCHAR(45) — Foreign key → user.id — NOT NULL
phone_certification
- user_id — VARCHAR(45) — Foreign key → user.id — NOT NULL
reservation
- id — INT — Primary key — NOT NULL
- biz_user_id — VARCHAR(45) — Foreign key → biz_user.id — NOT NULL
- iris_reg_id — INT — Foreign key → iris_registration_info.id — NOT NULL
shelter_user
- id — VARCHAR(45) — Primary key — NOT NULL
timeline
- id — INT — Primary key — NOT NULL
- biz_user_id — VARCHAR(45) — Foreign key → biz_user.id — NOT NULL
user
- id — VARCHAR(45) — Primary key — NOT NULL
- user_relation_info_id — INT — Foreign key → user_relation_info.id — NOT NULL
- primary_hospital_id — VARCHAR(45) — Foreign key → biz_user.id — NOT NULL
user_address
- user_id — VARCHAR(45) — Foreign key → user.id — NOT NULL
user_notice
- id — VARCHAR(45) — Primary key — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.id — NOT NULL
user_relation_info
- id — INT — Primary key — NOT NULL
- parent_id — VARCHAR(45)
- child_id — VARCHAR(45)