Carmoremile

Tables (9)

Agreement (terms agreement)

  • Agreement id (id) — INT — Primary key — NOT NULL
  • agreement — BOOL
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • User id (id2) — INT — Foreign key → User.User id — NOT NULL

Gift (gift)

  • Gift id (id) — INT — Primary key — NOT NULL
  • Gift category (category) — INT
  • Gift name (name) — VARCHAR(20)
  • Description (description) — TEXT
  • Serial code (code) — VARCHAR(50)
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • Won time (win_at) — DATETIME
  • Winner id (user_id) — INT — Foreign key → User.User id — NOT NULL

MileageHistory (Mileage history)

  • History id (id) — INT — Primary key — NOT NULL
  • User id (user_id) — INT — Foreign key → User.User id — NOT NULL
  • category — INT
  • Created time (create_at) — DATETIME
  • Changed mileage (delta) — INT

OpenAuth (Open Authentication)

  • OAuth id (id) — INT — Primary key — NOT NULL
  • User id (uesr_id) — INT — Foreign key → User.User id — NOT NULL
  • Kakao social id (kakao) — VARCHAR(20)
  • Naver social id (naver) — VARCHAR(20)
  • Google social id (google) — VARCHAR(20)
  • Apple social id (apple) — VARCHAR(20)
  • Kakao updated time (kakao_update_at) — DATETIME
  • Naver updated id (naver_update_at) — DATETIME
  • Google updated time (google_update_at) — DATETIME
  • Apple updated time (apple_update_at) — DATETIME

Penalty (User penalty)

  • Penalty id (id) — INT — Primary key — NOT NULL
  • User id (user_id) — INT — Foreign key → User.User id — NOT NULL
  • Start time (start_at) — DATETIME
  • End time (end_at) — DATETIME
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • Comment (comment) — TEXT

Region (Spot region)

  • Region id (id) — INT — Primary key — NOT NULL
  • Region name (name) — VARCHAR(20)
  • Description (description) — TEXT
  • Region index (index) — INT

Spot (Marketing spot)

  • Spot id (id) — INT — Primary key — NOT NULL
  • Region id (region_id) — INT — Foreign key → Region.Region id — NOT NULL
  • Latitude (latitude) — INT
  • Longitude (longitude) — INT
  • Spot radius (radius) — INT
  • Spot name (name) — VARCHAR(50)
  • Description (description) — TEXT
  • Visits count (visit) — INT
  • Like count (like) — INT
  • Report count (report) — INT
  • Updated time (update_at) — DATETIME
  • Created time (create_at) — DATETIME

Terms (terms)

  • Terms id (id) — INT — Primary key — NOT NULL
  • Title (title) — VARCHAR(50)
  • Content (content) — TEXT
  • Mandatory (mandatory) — BOOL
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • Agreement id (id2) — INT — Foreign key → Agreement.Agreement id — NOT NULL

User (membership)

  • User id (id) — INT — Primary key — NOT NULL
  • Nickname (nickname) — VARCHAR(20)
  • Password (password) — PASSWORD
  • Name (name) — VARCHAR(20)
  • Gender (gender) — INT
  • Phone (phone) — VARCHAR(11)
  • Email (email) — EMAIL
  • Profile image (image) — URI
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • Total mileage (total_mileage) — INT
  • Current mileage (current_mileage) — INT
  • Updated mileage (mileage_update_at) — DATETIME