mymoo

Tables (11)

Account(Donator) (계정)

  • Key (id) — bigint — Primary key — NOT NULL
  • 회원ID (email) — varchar
  • 회원PW (password) — varchar
  • 전화번호 (phone_number) — char
  • 닉네임 (nickname) — varchar
  • 포인트 (point) — bigint
  • 프사url (profile_image_url) — varchar

Address_new (도로명주소)

  • Key (id) — bigint — Primary key — NOT NULL
  • 음식점ID (store_id) — bigint — Foreign key → Store.Key — NOT NULL
  • 도 (do) — char(5)
  • 시/군 (sigun) — char(5)
  • 구 (gu) — char(5)
  • 로 (ro) — char(20)
  • 세부 (detail) — char(20)

Adress_old (기존주소)

  • Key (id) — bigint — Primary key — NOT NULL
  • 음식점ID (store_id) — bigint — Foreign key → Store.Key — NOT NULL
  • 도 (do) — char(5)
  • 시/군 (sigun) — char(5)
  • 구 (gu) — char(5)
  • 동읍면 (dong) — char(5)
  • 세부 (detail) — char(20)

Bookmark (찜한 음식점)

  • Key (id) — bigint — Primary key — NOT NULL
  • 계정ID (donator_id) — bigint — Foreign key → Account(Donator).Key — NOT NULL
  • 음식점ID (store_id) — bigint — Foreign key → Store.Key — NOT NULL

Child (결식 아동)

  • Key (id) — bigint — Primary key — NOT NULL
  • 계정ID (account_id) — bigint — Foreign key → Account(Donator).Key — NOT NULL
  • 카드번호(암호화) (card_number) — varchar

Donation (후원 관계)

  • Key (id) — bigint — Primary key — NOT NULL
  • 계정ID (donator_id) — bigint — Foreign key → Account(Donator).Key — NOT NULL
  • 음식점ID (store_id) — bigint — Foreign key → Store.Key — NOT NULL
  • 후원금액 (point) — bigint
  • 사용여부 (is_used) — bool

Donation_Usage (후원 금액 이용 관계)

  • Key (id) — bigint — Primary key — NOT NULL
  • 결식아동ID (child_id) — bigint — Foreign key → Child.Key — NOT NULL
  • 이용한후원ID (donation_id) — bigint — Foreign key → Donation.Key — NOT NULL
  • 감사의말 (message) — text

Like (좋아요한 음식점)

  • Key (id) — bigint — Primary key — NOT NULL
  • 계정ID (donator_id) — bigint — Foreign key → Account(Donator).Key — NOT NULL
  • 음식점ID (store_id) — bigint — Foreign key → Store.Key — NOT NULL

Location (거주지)

  • Key (id) — bigint — Primary key — NOT NULL
  • 아동ID (child_id) — bigint — Foreign key → Child.Key — NOT NULL
  • 도 (do) — char(10)
  • 시/군 (sigun) — char(10)
  • 구 (gu) — char(10)

Menu (메뉴)

  • Key (id) — bigint — Primary key — NOT NULL
  • 음식점ID (store_id) — bigint — Foreign key → Store.Key — NOT NULL
  • 메뉴명 (name) — varchar
  • 가격 (price) — int
  • url — varchar

Store (음식점)

  • Key (id) — bigint — Primary key — NOT NULL
  • 계정ID (id2) — bigint — Foreign key → Account(Donator).Key — NOT NULL
  • 은행 (bank) — varchar
  • 계좌번호 (bank_account) — int
  • 경도 (longitude) — double
  • 위도 (latitude) — double
  • 가게이미지 (image_url) — varchar
  • 총후원금액 (all_donation) — bigint
  • 사용가능한후원 (usable_donation) — bigint
  • 결식아동방문횟수 (visit_count) — int
  • 좋아요개수 (like_count) — int