ㅂㅈㄷㅂㄷ
Tables (18)
AdoptionConfirmation
- M_ID — varchar2(50) — NOT NULL
- AC_CHECK — varchar2(1000)
- AC_ID — varchar2(100)
- AC_ClassIfication — varchar2(100)
- AC_breed — varchar2(100)
- AC_Area — varchar2(100)
- AC_Gender — varchar2(10)
- AC_RegistrationNumber — varchar2(100)
- AC_ConfirmationDate — DATE
AnonymousBoard
- A_NUMBER — VARCHAR(255) — Primary key — NOT NULL
- A_NICK — varchar2(100)
- A_PWD — varchar2(100)
- A_CONTENT — varchar2(3000)
BANK
- B_CODE — varchar2(10) — Primary key — NOT NULL
- B_TITLE — varchar2(30) — NOT NULL
BuyConfirmation
- M_ID — varchar2(50) — Foreign key → Untitled.M_ID — NOT NULL
- BC_CHECK — varchar2(1000)
- BC_ID — varchar2(100)
- BC_ClassIfication — varchar2(100)
- BC_breed — varchar2(100)
- BC_Area — varchar2(100)
- BC_Gender — varchar2(10)
- BC_RegistrationNumber — varchar2(100)
- BC_ConfirmationDate — DATE
BuyerApply
- B_PET — varchar2(50) — Primary key — NOT NULL
- B_ID — varchar2(50) — Primary key — NOT NULL
- B_CODE — varchar2(10) — NOT NULL
- B_BANK — varchar2(100) — NOT NULL
CopyOfADOPT
- M_ID — varchar2(50) — Foreign key → Untitled.M_ID — NOT NULL
- PID — number — Foreign key → CopyOfPARCELOUT.PID — NOT NULL
- ANIMAL — varchar2(20)
- KIND — varchar2(20)
- LOCATION — varchar2(100)
- GENDER — varchar2(15)
- TIME — varchar2(50)
CopyOfPARCELOUT
- PID — number — Primary key — NOT NULL
- M_ID — varchar2(50) — Foreign key → Untitled.M_ID — NOT NULL
- Key — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
- PIC — varchar2(50)
- EXPLANATION — varchar2(1000)
- DEPOSIT — varchar2(50)
- TIME — varchar2(50)
CopyOfUntitled3
- Key — number — Primary key — NOT NULL
- Field2 — varchar2(100)
- Field3 — varchar2(50)
- Field4 — varchar2(1000)
- Field5 — date
DIVISION
- D_DIVISION — varchar2(10) — Primary key — NOT NULL
- D_TITLE — varchar2(20) — NOT NULL
LOGIN
- L_ID — varchar2(50) — NOT NULL
- L_LOGINTIME — date — NOT NULL
MEMBER
- M_NO — number — Primary key — NOT NULL
- M_ID — varchar2(50) — Primary key — NOT NULL
- M_NAME — varchar2(30) — NOT NULL
- M_PASSWORD — varchar2(60) — NOT NULL
- M_EMAIL — varchar2(100) — NOT NULL
- M_ADDRESS — varchar2(200) — NOT NULL
- M_PHONE — varchar2(100) — NOT NULL
- M_CODE — varchar2(10)
- M_ACCOUNT — varchar2(50)
- M_DIVISION — varchar2(10) — NOT NULL
- M_REGISTRATION — varchar2(50)
- M_JOINDATE — date — NOT NULL
- M_SECESSIONDATE — date
- M_EMAILCHECK — varchar2(100)
QUESTION
- Q_EMAIL — varchar2(50) — Primary key — NOT NULL
- Q_TITLE — varchar2(100) — NOT NULL
- Q_CONTENT — varchar2(1000) — NOT NULL
REGISTRATION_DB
- R_REGISTRATION — varchar2(30) — NOT NULL
- R_NAME — varchar2(30) — NOT NULL
- R_DATE — date — NOT NULL
- R_ANIMALNAME — varchar2(30) — NOT NULL
- R_AGE — varchar2(30) — NOT NULL
- R_GENDER — varchar2(10) — NOT NULL
- R_NEUTRALIZATION — varchar2(10) — NOT NULL
REPORT
- R_NO — varchar2(10) — Primary key — NOT NULL
- R_TITLE — varchar2(50) — NOT NULL
- R_ID — varchar2(30) — NOT NULL
- R_REPORTED_ID — varchar2(30) — NOT NULL
- R_EMAIL — varchar2(50) — NOT NULL
- R_DATE — date
REPORT_HISTORY
- RH_ID — varchar2(30) — Primary key — NOT NULL
- RH_EMAIL — varchar2(50) — NOT NULL
- RH_COUNT — varchar2(10)
- RH_DATE — date
- RH_RELEASE_DATE — date
Untitled
- Key — VARCHAR(255) — Primary key — NOT NULL
- M_ID — varchar2(50) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
Untitled2
- M_ID — varchar2(50) — Foreign key → Untitled.M_ID — NOT NULL
- PID — number — Foreign key → CopyOfPARCELOUT.PID — NOT NULL
- Field — VARCHAR(255)
Untitled3
- Key — number — Primary key — NOT NULL
- Field — number
- Field2 — varchar2(100)
- Field3 — varchar2(50)
- Field4 — varchar2(1000)
- Field5 — date