우주펫 DB

테이블 (8)

Animal (animal)

  • id — long — 기본 키 — NOT NULL
  • id (id2) — long — 외래 키 → User.id — NOT NULL
  • geometry — long — 외래 키 → User.geometry — NOT NULL
  • name — String
  • type — String
  • gender — String
  • breed — String
  • birthday — String
  • size — String
  • neutralization — Boolean
  • characteristics — String
  • personality — String
  • profile — String

Board (board)

  • id — long — 기본 키 — NOT NULL
  • neighborId (neighbor_id) — long — 기본 키 — NOT NULL
  • userId (user_id) — long — 외래 키 → User.id — NOT NULL
  • id (id2) — long — 외래 키 → User.geometry — NOT NULL
  • requestContent (request_content) — string — NOT NULL
  • specialNote (special_note) — string
  • preMeeting (pre_meeting) — string
  • requestedDate (requested_date) — DATETIME
  • createdDate (created_date) — DATETIME
  • deleted — boolean
  • severalAnimals (several_animals) — Boolean
  • connected — boolean

Chat (chat)

  • id — long — 기본 키 — NOT NULL
  • user1 — long — 외래 키 → User.id — NOT NULL
  • user2 — long — 외래 키 → User.geometry — NOT NULL
  • user1Block (user1block) — boolean
  • user2Block (user2block) — boolean
  • createdDate (created_date) — DATETIME

Geometry (geometry)

  • id — long — 기본 키 — NOT NULL
  • sido — string — NOT NULL
  • sigungu — string
  • dong — string
  • ro — string
  • number — string
  • location — string

PhoneAuth (phone_auth)

  • id — long — 기본 키 — NOT NULL
  • phoneNumber (phone_number) — string
  • authNumber (auth_number) — string
  • createdAt (created_at) — DATETIME

Promise (promise)

  • id — long — 기본 키 — NOT NULL
  • chatId (chat_id) — long — 외래 키 → Chat.id — NOT NULL
  • user1 — long — 외래 키 → Chat.user1 — NOT NULL
  • user2 — long — 외래 키 → Chat.user2 — NOT NULL
  • name — string
  • startDate (start_date) — DATETIME
  • checkCareFinish (check_care_finish) — boolean

Report (report)

  • id — long — 기본 키 — NOT NULL
  • writerId (writer_id) — long — 외래 키 → User.id — NOT NULL
  • reportedUserId (reported_user_id) — long — 외래 키 → User.geometry — NOT NULL
  • content — string
  • createdDate (created_date) — DATETIME

User (user)

  • id — long — 기본 키 — NOT NULL
  • geometry — long — 외래 키 → Geometry.id — NOT NULL
  • uid — string
  • birthday — String
  • delete (detele) — Boolean
  • gender — String — 0 : 남자 : Male 1 : 여자 : Female
  • phoneNumber (phone_number) — String
  • hospital — String
  • give — Int
  • take — Int
  • introduction — String
  • profile — String
  • token — String
  • animal — long — NOT NULL