petmily2

Tables (11)

abandoned_animal

  • abandoned_animal_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • age — int
  • kind — varchar(255)
  • name — varchar(255)
  • species — varchar(255)
  • status — varchar(255)
  • weight — float

adopt

  • application_id — bigint — Primary key — NOT NULL
  • application_id (application_id2) — bigint — Foreign key → application.application_id — NOT NULL
  • job — varchar(255)
  • location — int
  • married — bit(1)

application

  • application_id — bigint — Primary key — NOT NULL
  • app_type — varchar(31) — NOT NULL
  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • application_status — varchar(255)
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • abandoned_animal_id — bigint — Foreign key → abandoned_animal.abandoned_animal_id — NOT NULL

board

  • board_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • board_type — varchar(255)
  • content — varchar(255)
  • shown_all — bit(1)
  • title — varchar(255)
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

donation

  • application_id — bigint — Foreign key → application.application_id — NOT NULL
  • account_number — bigint
  • account_number_with_hyphen — varchar(255)
  • amount — int
  • bank_type — varchar(255)
  • donator — varchar(255)

find_watch_board

  • board_id — bigint — Foreign key → board.board_id — NOT NULL
  • animal_age — int
  • animal_kind — varchar(255)
  • animal_name — varchar(255)
  • animal_weight — float
  • board_status — int
  • lost_or_watch_time — datetime(6)
  • species — int

match_info

  • id — bigint — Primary key — NOT NULL
  • matched_board_board_id — bigint — Foreign key → find_watch_board.board_id — NOT NULL
  • target_board_board_id — bigint — Foreign key → find_watch_board.board_id — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • birth — date
  • domain — varchar(255)
  • id — varchar(255)
  • site — varchar(255)
  • grade — varchar(255)
  • login_id — varchar(255)
  • name — varchar(255)
  • password — varchar(255)
  • end_number — varchar(255)
  • middle_number — varchar(255)
  • start_number — varchar(255)

picture

  • picture_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • file_store_name — varchar(255)
  • file_upload_name — varchar(255)
  • abandoned_animal_id — bigint — Foreign key → abandoned_animal.abandoned_animal_id — NOT NULL
  • board_id — bigint — Foreign key → board.board_id — NOT NULL

reply

  • reply_id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • content — varchar(255)
  • board_id — bigint — Foreign key → board.board_id — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

temporary_protection

  • application_id — bigint — Foreign key → application.application_id — NOT NULL
  • job — varchar(255)
  • location — int
  • married — bit(1)
  • period — int