petmily
Tables (11)
ABANDONED_ANIMAL
- ABANDONED_ANIMAL_ID — NUMBER(19,0) — Primary key — NOT NULL
- CREATED_DATE — TIMESTAMP
- LAST_MODIFIED_DATE — TIMESTAMP
- AGE — NUMBER(10,0)
- KIND — VARCHAR2(255 CHAR)
- NAME — VARCHAR2(255 CHAR)
- SPECIES — VARCHAR2(255 CHAR)
- STATUS — VARCHAR2(255 CHAR)
- WEIGHT — FLOAT(126)
ADOPT
- APPLICATION_ID (APPLICATION_ID2) — NUMBER(19,0) — Foreign key → APPLICATION.APPLICATION_ID — NOT NULL
- JOB — VARCHAR2(255 CHAR)
- LOCATION — NUMBER(10,0)
- MARRIED — NUMBER(1,0)
APPLICATION
- APPLICATION_ID — NUMBER(19,0) — Primary key — NOT NULL
- APP_TYPE — VARCHAR2(31 CHAR) — NOT NULL
- CREATED_DATE — TIMESTAMP
- LAST_MODIFIED_DATE — TIMESTAMP
- APPLICATION_STATUS — VARCHAR2(255 CHAR)
- MEMBER_ID — NUMBER(19,0) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- ABANDONED_ANIMAL_ID — NUMBER(19,0) — Foreign key → ABANDONED_ANIMAL.ABANDONED_ANIMAL_ID — NOT NULL
BOARD
- BOARD_ID — NUMBER(19,0) — Primary key — NOT NULL
- CREATED_DATE — TIMESTAMP
- LAST_MODIFIED_DATE — TIMESTAMP
- BOARD_TYPE — VARCHAR2(255 CHAR)
- CONTENT — VARCHAR2(255 CHAR)
- SHOWN_ALL — NUMBER(1,0)
- TITLE — VARCHAR2(255 CHAR)
- MEMBER_ID (MEMBER_ID2) — NUMBER(19,0) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
DONATION
- APPLICATION_ID (APPLICATION_ID2) — NUMBER(19,0) — Foreign key → APPLICATION.APPLICATION_ID — NOT NULL
- ACCOUNT_NUMBER — NUMBER(19,0)
- ACCOUNT_NUMBER_WITH_HYPHEN — VARCHAR2(255 CHAR)
- AMOUNT — NUMBER(10,0)
- BANK_TYPE — VARCHAR2(255 CHAR)
- DONATOR — VARCHAR2(255 CHAR)
FIND_WATCH_BOARD
- BOARD_ID (BOARD_ID2) — NUMBER(19,0) — Foreign key → BOARD.BOARD_ID — NOT NULL
- ANIMAL_AGE — NUMBER(10,0)
- ANIMAL_KIND — VARCHAR2(255 CHAR)
- ANIMAL_NAME — VARCHAR2(255 CHAR)
- ANIMAL_WEIGHT — FLOAT(126)
- BOARD_STATUS — NUMBER(10,0)
- LOST_OR_WATCH_TIME — TIMESTAMP
- SPECIES — NUMBER(10,0)
MATCH_INFO
- ID — NUMBER(19,0) — Primary key — NOT NULL
- MATCHED_BOARD_BOARD_ID — NUMBER(19,0) — Foreign key → FIND_WATCH_BOARD.BOARD_ID — NOT NULL
- TARGET_BOARD_BOARD_ID — NUMBER(19,0) — Foreign key → FIND_WATCH_BOARD.BOARD_ID — NOT NULL
MEMBER
- MEMBER_ID — NUMBER(19,0) — Primary key — NOT NULL
- CREATED_DATE — TIMESTAMP
- LAST_MODIFIED_DATE — TIMESTAMP
- BIRTH — DATE
- DOMAIN — VARCHAR2(255 CHAR)
- ID — VARCHAR2(255 CHAR)
- SITE — VARCHAR2(255 CHAR)
- GRADE — VARCHAR2(255 CHAR)
- LOGIN_ID — VARCHAR2(255 CHAR)
- NAME — VARCHAR2(255 CHAR)
- PASSWORD — VARCHAR2(255 CHAR)
- END_NUMBER — VARCHAR2(255 CHAR)
- MIDDLE_NUMBER — VARCHAR2(255 CHAR)
- START_NUMBER — VARCHAR2(255 CHAR)
PICTURE
- PICTURE_ID — NUMBER(19,0) — Primary key — NOT NULL
- CREATED_DATE — TIMESTAMP
- LAST_MODIFIED_DATE — TIMESTAMP
- FILE_STORE_NAME — VARCHAR2(255 CHAR)
- FILE_UPLOAD_NAME — VARCHAR2(255 CHAR)
- BOARD_ID (BOARD_ID2) — NUMBER(19,0) — Foreign key → BOARD.BOARD_ID — NOT NULL
- ABANDONED_ANIMAL_ID (ABANDONED_ANIMAL_ID2) — NUMBER(19,0) — Foreign key → ABANDONED_ANIMAL.ABANDONED_ANIMAL_ID — NOT NULL
REPLY
- REPLY_ID — NUMBER(19,0) — Primary key — NOT NULL
- CREATED_DATE — TIMESTAMP
- LAST_MODIFIED_DATE — TIMESTAMP
- CONTENT — VARCHAR2(255 CHAR)
- MEMBER_ID (MEMBER_ID2) — NUMBER(19,0) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- BOARD_ID (BOARD_ID2) — NUMBER(19,0) — Foreign key → BOARD.BOARD_ID — NOT NULL
TEMPORARY_PROTECTION
- APPLICATION_ID — NUMBER(19,0) — Foreign key → APPLICATION.APPLICATION_ID — NOT NULL
- JOB — VARCHAR2(255 CHAR)
- LOCATION — NUMBER(10,0)
- MARRIED — NUMBER(1,0)
- PERIOD — NUMBER(10,0)