me

Tables (9)

Copy Of Copy Of Untitled2 (Used_Point)

  • Key (id) — LONG — Primary key — NOT NULL
  • Field (amount) — INT
  • Field (created_at) — DATETIME
  • Key (point_id) — LONG — Foreign key → Copy Of Copy Of Untitled22.Key — NOT NULL

Copy Of Copy Of Untitled22 (Point)

  • Key (id) — LONG — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key → User.Key — NOT NULL

Copy Of Copy Of User (Coupon)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key → User.Key — NOT NULL
  • Key (coupon_id) — UUID — Foreign key → Copy Of Copy Of User2.Key — NOT NULL
  • Field (created_at) — DATETIME

Copy Of Copy Of User2 (inventory)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (gifticon_id) — UUID — Foreign key → Copy Of User.Key — NOT NULL
  • Field (expired_at) — DATETIME
  • Key (created_at) — DATETIME — NOT NULL
  • Field (barcode_url) — TEXT

Copy Of Untitled2 (Saved_Point)

  • Key (id) — LONG — Primary key — NOT NULL
  • Field (amount) — INT
  • Field (created_at) — DATETIME
  • Key (point_id) — LONG — Foreign key → Copy Of Copy Of Untitled22.Key — NOT NULL

Copy Of User (Gifticon)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (name) — VARCHAR(50)
  • Field (point) — INT
  • Field (notice) — TEXT
  • Field (brand) — VARCHAR(50)
  • Field (profile_url) — TEXT

Untitled (Order)

  • Key — LONG — Primary key — NOT NULL
  • Field (created_at) — DATETIME
  • Key (coupon_id) — UUID — Foreign key → Copy Of Copy Of User.Key — NOT NULL
  • Key (used_point_id) — LONG — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL

Untitled2 (Exercise)

  • Key (id) — LONG — Primary key — NOT NULL
  • Field (calorie) — INT
  • Key (type) — ExerciseType — NOT NULL
  • Key (user_id) — UUID — Foreign key → User.Key — NOT NULL
  • Key (saved_point_id) — LONG — Foreign key → Copy Of Untitled2.Key — NOT NULL

User

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (name) — VARCHAR(10)
  • Field (role) — Role
  • Field (email) — VARCHAR(255)