우주펫 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