세미
테이블 (8)
adopt_board
- id — number — 기본 키
- animal_id — number
- member_id — number — NOT NULL
- proces — number
- reg_date — date
- id (id2) — number — 외래 키 → animal.id
- id (id3) — number — 외래 키 → member.id
animal
- id — number — 기본 키
- age — number
- attachment_id — number — NOT NULL
- discvry_plc — varchar(300)
- animal_type — varchar(20)
- species — varchar(20)
- weight — number
- pbl_id — varchar(100)
- state — varchar(100)
- sex — varchar(10)
- neutered — number
answer
- id — number — 기본 키
- member_id — number
- question_id — number
- content — varchar2(4000)
- reg_date — date
- id (id3) — number — 외래 키 → member.id
- id (id2) — number — 외래 키 → question.id
attachment
- id — number — 기본 키
- enroll_board_id — number — NOT NULL
- original_filename — varchar2(255) — NOT NULL
- renamed_filename — varchar2(255) — NOT NULL
- reg_date — date
- id (id2) — number — 외래 키 → enroll_board.id
- id (id3) — number — 외래 키 → enroll_board.id
chatlog
- id — number — 기본 키
- member_id — number
- content — varchar2(4000)
- reg_date — date
- id (id2) — number — 외래 키 → member.id
enroll_board
- id — number — 기본 키
- animal_id — number — NOT NULL
- reg_date — date
- id (id3) — number — 외래 키 → animal.id
member
- id — number — 기본 키
- member_id — varchar2(20)
- password — varchar2(300) — NOT NULL
- name — varchar2(50) — NOT NULL
- member_role — varchar(59) — NOT NULL
- email — varchar2(200)
- phone — char(20) — NOT NULL
- reg_date — date
- address — varchar(100)
- provider — varchar(50)
question
- id — number — 기본 키
- member_id — number
- title — varchar(50)
- content — varchar(4000)
- reg_date — date
- id (id2) — number — 외래 키 → member.id