백엔드 erd
테이블 (11)
API_KEY (apiKey)
- Id (1) — BIGINT — 기본 키 — NOT NULL
- api_key (84711cec18cf4d52b2dbfbf03f20f17b) — UUID
- created_date (2024-04-15) — Date
- expiration_date (2025-04-15) — Date
- valid (true) — Boolean
AffiliateDiscount (affiliate_discount)
- discount_id (1) — BIGINT — 기본 키 — NOT NULL
- table_id (12) — BIGINT — 외래 키 → Table.table_id — NOT NULL
- title (교보문고 10%할일) — String
- content (교보문고 10% 할인을 시작합니다..) — String
- start_date (2024-10-1) — Date
- end_date (2024-10-20) — Date
- location — Location
- created_at (2024-04-15) — Date
AffiliateLocation (affilicate_location)
- location_id (1) — BIGINT — 기본 키 — NOT NULL
- discount_id (12) — BIGINT — 외래 키 → AffiliateDiscount.discount_id — NOT NULL
- location — Location
- store_name (교보문고) — String
- Field
AffilicateImage (affilicate_image)
- image_id (1) — BIGINT — 기본 키 — NOT NULL
- discount_id (12) — BIGINT — 외래 키 → AffiliateDiscount.discount_id — NOT NULL
- image_url (https:s3/~~~) — String
FcmKey (fcm_key)
- user_id (1) — BIGINT — 외래 키 → User.user_id — NOT NULL
- fcm_token (891h27rfh2n!dj) — Stirng
- created_at (2024-05-12) — Date
Notification (notification)
- notification_id (1) — BIGINT — 기본 키 — NOT NULL
- user_id (12) — BIGINT — 외래 키 → User.user_id — NOT NULL
- title (할인 정보) — String
- content (내 주변에 할인을 받을 수 있는...) — String
- notification_type (할인정보) — Enum
Payment (payment)
- payment_id (1) — BIGINT — 기본 키 — NOT NULL
- user_id (2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- price (10000) — BINGINT
- created_at (2024-05-12) — Date
- is_affiliate (true) — Boolean
- payment_type (food) — Enum
Similarity (similiarty)
- similarity_id (1) — BIGINT — 기본 키 — NOT NULL
- table_id (12) — BIGINT — 외래 키 → Table.table_id — NOT NULL
- table_id (13) — BIGINT — 외래 키 → Table.table_id — NOT NULL
- score (0.56) — Double
SolPayAccount (sol_pay_account)
- user_id (12) — BIGINT — 외래 키 → User.user_id — NOT NULL
- account_id (001--fhjajks) — String
- password (123456) — String
- created_at (2024-05-14) — Date
Table (table)
- table_id (1) — BIGINT — 기본 키 — NOT NULL
- Field (중식) — String
User (user)
- user_id (1) — BIGINT — 기본 키 — NOT NULL
- user_email ([email protected]) — String
- password (1u2bnur@fd92j) — String
- created_at (2024-04-15) — Date
- Name (김싸피) — String
- university (싸피대학교) — Enum