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