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