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