Reframe
Tables (6)
loves (즐겨찾기)
- 좋아요ID (id) — INT — Primary key — NOT NULL
- 멤버ID (member_id) — INT — Foreign key → members.멤버ID — NOT NULL
- 가맹점ID (id2) — INT — Foreign key → stores.가맹점ID — NOT NULL
members (사용자)
- 멤버ID (id) — INT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(100)
- 이메일 (email) — VARCHAR(100)
- 비밀번호 (password) — VARCHAR(100)
- 생성날짜 (created_at) — TimeStamp
- 수정날짜 (updated_at) — TimeStamp
- 삭제날짜 (deleted_at) — TimeStamp
points (포인트 내역)
- 포인트ID (id) — INT — Primary key — NOT NULL
- 영수증ID (receipt_id) — INT — Foreign key → receipts.영수증ID — NOT NULL
- 멤버ID (member_id) — INT — Foreign key → members.멤버ID — NOT NULL
- 포인트 (amount) — INT
- 내역 (type) — enum: REWARD, USE
- 생성날짜 (created_at) — TimeStamp
- 수정날짜 (updated_at) — TimeStamp
- 삭제날짜 (deleted_at) — TimeStamp
receipts (영수증)
- 영수증ID (id) — INT — Primary key — NOT NULL
- 금액 (Field) — INT
- 생성날짜 (created_at) — TimeStamp
- 수정날짜 (updated_at) — TimeStamp
- 삭제날짜 (deleted_at) — TimeStamp
- 멤버ID (member_id) — INT — Foreign key → members.멤버ID — NOT NULL
- 가맹점ID (store_id) — INT — Foreign key → stores.가맹점ID — NOT NULL
reviews (리뷰)
- 리뷰ID (id) — INT — Primary key — NOT NULL
- 멤버ID (member_id) — INT — Foreign key → members.멤버ID — NOT NULL
- 가맹점ID (store_id) — INT — Foreign key → stores.가맹점ID — NOT NULL
- 내용 (content) — text
- 별점 (rating) — INT
- 생성날짜 (created_at) — TimeStamp
- 수정날짜 (updated_at) — TimeStamp
- 삭제날짜 (deleted_at) — TimeStamp
stores (가맹점)
- 가맹점ID (id) — INT — Primary key — NOT NULL
- 상호명 (name) — VARCHAR(100)
- 주소 (address) — text
- 사업자등록번호 (business_number) — text
- 경도 (lat) — float
- 위도 (lng) — float
- 생성날짜 (created_at) — TimeStamp
- 수정날짜 (updated_at) — TimeStamp
- 삭제날짜 (deleted_at) — TimeStamp
- 리뷰수 (count) — INT
- 평균별점 (avg_rating) — float