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)