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 성별