백엔드 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