ㄴㅇㄹ

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