erd

Tables (6)

admin

  • a_no — BIGINT(20) — Primary key — NOT NULL
  • a_id — VARCHAR(50) — NOT NULL
  • a_pass — VARCHAR(100) — NOT NULL
  • a_name — VARCHAR(100) — NOT NULL

adoption_application

  • id — BIGINT(20) — Primary key — NOT NULL
  • u_id — VARCHAR(100) — NOT NULL
  • motivation — TEXT — NOT NULL
  • housing_type — VARCHAR(50) — NOT NULL
  • pet_allowed — VARCHAR(50)
  • family_info — VARCHAR(255)
  • allergy_info — VARCHAR(100)
  • current_pets — VARCHAR(255)
  • experience — TEXT
  • job — VARCHAR(50)
  • work_type — VARCHAR(50)
  • pet_care_plan — TEXT
  • financial_status — VARCHAR(20)
  • care_time — VARCHAR(50)
  • exercise_plan — VARCHAR(100)
  • travel_plan — TEXT
  • agreement — TINYINT(1) — NOT NULL
  • created_at — DATETIME
  • pledge — TINYINT(4)
  • housing — VARCHAR(100)
  • animal_id — BIGINT(20) — NOT NULL
  • animal_name — VARCHAR(255)
  • animal_type — VARCHAR(500)
  • animal_detail — VARCHAR(255)
  • status — ENUM('승인대기','승인불허','승인완료')

adoption_review

  • ar_no — BIGINT(20) — Primary key — NOT NULL
  • author_uid — VARCHAR(255) — NOT NULL
  • review_content — MEDIUMTEXT
  • created_at — DATETIME
  • view_count — INT(11)
  • like_count — INT(11)
  • ar_title — VARCHAR(255)

board

  • b_no — BIGINT(20) — Primary key — NOT NULL
  • b_title — VARCHAR(255) — NOT NULL
  • b_content — MEDIUMTEXT — NOT NULL
  • author_uid — VARCHAR(100) — NOT NULL
  • b_date — DATETIME
  • view_count — INT(11)
  • like_count — INT(11)

comment

  • cm_no — BIGINT(20) — Primary key — NOT NULL
  • post_id — BIGINT(20) — NOT NULL
  • board_type — VARCHAR(50) — NOT NULL
  • author_uid — VARCHAR(100) — NOT NULL
  • cm_writer — VARCHAR(100) — NOT NULL
  • cm_content — MEDIUMTEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • u_no — BIGINT(20) — Primary key — NOT NULL
  • u_id — VARCHAR(100) — NOT NULL
  • u_pass — VARCHAR(100) — NOT NULL
  • u_name — VARCHAR(100) — NOT NULL
  • u_pnumber — VARCHAR(20)
  • u_email — VARCHAR(100) — NOT NULL
  • u_gender — VARCHAR(1) — NOT NULL
  • u_birthdate — DATE