세미

테이블 (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