ㄴㅇㄹ
Tables (47)
Untitled
- sigungu_id — INT — Primary key — NOT NULL
- sigungu_code — VARCHAR(20)
- sigungu_name — VARCHAR(20)
- sido_id — INT — NOT NULL
Untitled4
- sido_id — INT — Primary key — NOT NULL
- sido_code — VARCHAR(20) — NOT NULL
- sido_name — VARCHAR(20) — NOT NULL
adoptionPost
- id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- user_phone — VARCHAR(20) — NOT NULL
- animal_type — ENUM('CAT','DOG') — NOT NULL
- breed — VARCHAR(20) — NOT NULL
- age — INT — NOT NULL
- color — VARCHAR(20) — NOT NULL
- gender — ENUM('MALE','FEMALE') — NOT NULL
- weight — DECIMAL(4,2) — NOT NULL
- status — ENUM(PROTECTING', 'ADOPTED') — NOT NULL
- neutering — ENUM('Y','N') — NOT NULL
- view — INT — NOT NULL
- is_blind — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- user_id — INT
- head_id — INT
- sigungu_id — INT — NOT NULL
adoptionPostComment
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- is_blinded — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
adoptionPostCommentReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- comment_id — INT — NOT NULL
- user_id — INT
- head_id — INT
adoptionPostFiles
- id — integer — Primary key — NOT NULL
- rename — VARCHAR(100) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- uploaded_at — VARCHAR(20) — NOT NULL
- adoption_post_id — int — NOT NULL
adoptionPostLiked
- adoption_post_id — integer — Foreign key → adoptionPost.id — NOT NULL
- user_id — VARCHAR(255) — Foreign key → user.user_id
- head_id — VARCHAR(255) — Foreign key → shelter_head.head_id
adoptionPostReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
donationPost
- id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- view — INT — NOT NULL
- head_id — INT — NOT NULL
donationPostComment
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
donationPostCommentReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- comment_id — INT — NOT NULL
- user_id — INT
- head_id — INT
donationPostFiles
- id — INT — Primary key — NOT NULL
- rename — varchar(255) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- uploaded_at — VARCHAR(20) — NOT NULL
- post_id — INT — NOT NULL
donationPostLiked
- id — INT — Foreign key → donationPost.id — NOT NULL
- user_id — INT — Foreign key → user.user_id
- head_id — INT — Foreign key → shelter_head.head_id
loginHistory
- login_history_id — INT — Primary key — NOT NULL
- ip_address — VARCHAR(39) — NOT NULL
- logged_at — VARCHAR(20) — NOT NULL
- user_id — INT
- head_id — INT
message
- id — INT — Primary key — NOT NULL
- content — text — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- message_number — INT — NOT NULL
- subject_user_id — INT
- send_user_id — INT
- subject_head_id — INT
- send_head_id — INT
missingPost
- id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- is_blinded — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- status — BOOLEAN — NOT NULL
- detail_address — VARCHAR(50)
- gender — ENUM('MALE','FEMALE') — NOT NULL
- age — INT
- registration_num — INT
- breed — VARCHAR(20)
- animal_type — ENUM('CAT','DOG') — NOT NULL
- color — VARCHAR(20)
- weight — DECIMAL(4,2)
- lost_date — VARCHAR(20) — NOT NULL
- feature — TEXT
- contact — VARCHAR(20)
- view — INT — NOT NULL
- user_id — INT
- head_id — INT
- sigungu_id — INT — NOT NULL
missingPostComment
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- is_deleted — BOOLEAN — NOT NULL
- is_blinded — BOOLEAN — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
missingPostCommentReport
- id — INT — Primary key — NOT NULL
- report_category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- report_etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- comment_id — INT — NOT NULL
- user_id — INT
- head_id — INT
missingPostFiles
- id — INT — Primary key — NOT NULL
- rename — VARCHAR(100) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- uploaded_at — VARCHAR(20) — NOT NULL
- post_id — INT — NOT NULL
missingPostReport
- id — INT — Primary key — NOT NULL
- report_category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- report_etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
notice
- notice_id — INT — Primary key — NOT NULL
- notice_title — VARCHAR(50) — NOT NULL
- notice_content — TEXT — NOT NULL
- notice_created_at — VARCHAR(20) — NOT NULL
- notice_updated_at — VARCHAR(20)
- rating_id — INT — NOT NULL
noticeFiles
- id — INT — Primary key — NOT NULL
- rename — VARCHAR(100) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- uploaded_at — VARCHAR(20) — NOT NULL
- notice_id — INT — NOT NULL
noticeLiked
- notice_id — INT — Foreign key → notice.notice_id — NOT NULL
- user_id — INT — Foreign key → user.user_id
- director_id — INT — Foreign key → shelter_head.head_id
post
- id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- view — INT — NOT NULL
- is_blinded — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- user_id — INT
- head_id — INT
postComment
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- is_blinded — BOOLEAN — NOT NULL
- is_deleted — BOLEAN — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
postCommentReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- comment_id — INT — NOT NULL
- user_id — INT
- head_id — INT
postFiles
- id — INT — Primary key — NOT NULL
- rename — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- uploaded_at — VARCHAR(20) — NOT NULL
- post_id — INT — NOT NULL
postLiked
- post_id — INT — Foreign key → post.id — NOT NULL
- user_id — INT — Foreign key → user.user_id
- head_id — INT — Foreign key → shelter_head.head_id
postReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
rating
- rating_id — INT — Primary key — NOT NULL
- rating_name — VARCHAR(10) — NOT NULL
- rating_standard — INT — NOT NULL
shelter_head
- head_id — INT — Primary key — NOT NULL
- head_name — VARCHAR(20) — NOT NULL
- head_account — VARCHAR(20) — NOT NULL
- head_password — VARCHAR(255) — NOT NULL
- ceo_name — VARCHAR(20) — NOT NULL
- ceo_name2 — VARCHAR(20) — NOT NULL
- company_name — VARCHAR(255) — NOT NULL
- biz_number — VARCHAR(20) — NOT NULL
- cor_number — VARCHAR(20) — NOT NULL
- company_address — VARCHAR(255) — NOT NULL
- open_date — VARCHAR(20) — NOT NULL
- close_date — VARCHAR(20) — NOT NULL
- sigungu_id — INT — NOT NULL
sightingPost
- id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated.at — VARCHAR(20)
- sighted_at — VARCHAR(20) — NOT NULL
- sighted_place — VARCHAR(255) — NOT NULL
- color — VARCHAR(20) — NOT NULL
- animal_type — ENUM('CAT','DOG') — NOT NULL
- breed — VARCHAR(20) — NOT NULL
- view — INT — NOT NULL
- is_blinded — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- user_id — INT
- head_id — INT
- sigungu_id — INT — NOT NULL
sightingPostComment
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- is_blinded — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- sighting_post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
sightingPostCommentReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — VARCHAR(255)
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- sighting_post_comment_id — INT — NOT NULL
- user_id — INT
- head_id — INT
sightingPostFiles
- id — INT — Primary key — NOT NULL
- rename — VARCHAR(100) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- uploaded_at — VARCHAR(20) — NOT NULL
- sighting_post_id — INT — NOT NULL
sightingPostLiked
- sighting_post_id — INT — Foreign key → sightingPost.id — NOT NULL
- user_id — INT — Foreign key → user.user_id
- head_id — INT — Foreign key → shelter_head.head_id
sightingPostReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- sighting_post_id — INT — NOT NULL
- user_id — INT
- head_id — INT
user
- user_id — INT — Primary key — NOT NULL
- user_name — VARCHAR(20) — NOT NULL
- user_account — VARCHAR(20) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- detail_address — VARCHAR(255)
- user_phone — VARCHAR(20) — NOT NULL
- cumulative_volunteer_time — INT — NOT NULL
- month_volunteer_time — INT
- volunteer_count — INT — NOT NULL
- deactivation_times — INT — NOT NULL
- user_status — ENUM("GENERAL","BLACK","CANCEL") — NOT NULL
- acticivation_date — VARCHAR(20) — NOT NULL
- rating_id — INT — NOT NULL
- sigungu_id — INT — NOT NULL
volunteerAssociation
- id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — text
- created_at — VARCHAR(20) — NOT NULL
- volunteer_time — INT — NOT NULL
- volunteer_start_date — VARCHAR(20) — NOT NULL
- detail_address — VARCHAR(255)
- deadline — BOOLEAN
- number_of_people — INT
- user_id — INT — NOT NULL
- sigungu_id — INT — NOT NULL
volunteerAssociationApplicationDetails
- id — INT — Primary key — NOT NULL
- status — BOOLEAN
- volunteer_association_id — INT — NOT NULL
- user_id — INT — NOT NULL
volunteerKing
- id — INT — Primary key — NOT NULL
- category — BOOLEAN — NOT NULL
- year — INT
- month — INT
- volunteer_time — INT
- user_id — INT — NOT NULL
volunteerPost
- id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- Field — INT — NOT NULL
- is_blinded — BOOLEAN — NOT NULL
- is_deleted — BOLLEAN — NOT NULL
- head_id — INT — NOT NULL
volunteerPostComment
- id — INT — Primary key — NOT NULL
- content — TEXT
- created_at — VARCHAR(20) — NOT NULL
- updated_at — VARCHAR(20)
- is_blinded — INT — NOT NULL
- is_deleted — INT — NOT NULL
- head_id — INT — NOT NULL
- user_id — INT — NOT NULL
- post_id — INT — NOT NULL
volunteerPostCommentReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- comment_id — INT — NOT NULL
- head_id — INT
- user_id — INT
volunteerPostFiles
- id — INT — Primary key — NOT NULL
- rename — VARCHAR(100) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- uploaded_at — VARCHAR(20) — NOT NULL
- post_id — INT — NOT NULL
volunteerPostLiked
- post_id — int — Foreign key → volunteerPost.id — NOT NULL
- user_id — int — Foreign key → user.user_id — NOT NULL
- head_id — int — Foreign key → shelter_head.head_id — NOT NULL
volunteerPostReport
- id — INT — Primary key — NOT NULL
- category — ENUM('SPAM','ABUSE','PORN','FRAUD','MISINFO','ETC') — NOT NULL
- etc_detail — TEXT
- created_at — VARCHAR(20) — NOT NULL
- status — BOOLEAN — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT
- head_id — INT