MyFriendBongsik
Tables (8)
Carts (CARTS)
- Cart ID (cid) — String — Primary key — NOT NULL
- Product Amount (prodAmount) — int — Primary key — NOT NULL
- User ID (uid) — String — Foreign key → USERS.User ID — NOT NULL — 돌봄 서비스 사용자 ID
- Volunteer ID (vid) — String — Foreign key → USERS.Volunteer ID — NOT NULL — 생활 지원사 ID
- Product Name (prod_name) — String — Foreign key → PRODUCTS.Product Name — NOT NULL
- Reservation Date (reservDate) — String
EMERGENCY PHONEBOOK (phoneBook)
- Emerge Phone ID (eid) — String — Primary key — NOT NULL
- User ID (uid) — String — Foreign key → USERS.User ID — NOT NULL — 돌봄 서비스 사용자 ID
- Emerge Phone Name (name) — String
- Emerge Phone No (phone) — String
PRODUCTS
- Product Name (prodName) — String — Primary key — NOT NULL
- Product Total Amount (prodTotalAmount) — int
- Product ID (pid) — String
- Product Image (prodImage) — String
RESERVATION INFO (RESERVATION)
- Reservation ID (reserv_id) — int — Primary key — NOT NULL
- User ID (uid) — String — Foreign key → USERS.User ID — NOT NULL — 돌봄 서비스 사용자 ID
- Volunteer ID (vid) — String — Foreign key → USERS.Volunteer ID — NOT NULL — 생활 지원사 ID
- Reservation date (reservDate) — String
- Request (request) — String — NOT NULL
- Visit Info (visitYn) — String
- User Address (address) — String — address + addressDetail
USER LOCATIONS (UserLocation)
- User ID (uid) — String — Foreign key → USERS.User ID — NOT NULL — 돌봄 서비스 사용자 ID
- Latitude — LatLng
- Longtitude — LatLng
USERS
- User ID (uid) — String — Primary key — NOT NULL — 돌봄 서비스 사용자 ID
- Volunteer ID (vid) — String — Foreign key → VOLUSERS.Volunteer ID — NOT NULL — 생활 지원사 ID
- User Password (pwd) — String — 돌봄 서비스 사용자 password
- User Name (name) — String
- User Phone (phone) — String
- User Birthday (birthday) — String
- User Sex (sex) — String
- User Address (address) — String
- User Address Detail (addressDetail) — String
User Stats (STATS)
- Product Amount (prodAmount) — int — Foreign key → Carts.Product Amount — NOT NULL
- User ID (uid) — String — Foreign key → Carts.User ID — NOT NULL — 돌봄 서비스 사용자 ID
- Product Name (prod_name) — String — Foreign key → Carts.Product Name — NOT NULL
VOLUSERS
- Volunteer ID (vid) — String — Primary key — NOT NULL — 생활 지원사 ID
- Volunteer Password (pwd) — String — 생활 지원사 password
- Volunteer Name (name) — String — 생활 지원사 이름
- Volunteer Phone No (phone) — String — 생활지원사 핸드폰 번호
- Volunteer Birthday (birth) — String — 생활 지원사 생년월일
- Volunteer Sex (sex) — String — Volunteer 성별