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