SeTI-P

Tables (4)

AuthToken (cm_user_token)

  • token (id) — bigint — Primary key — NOT NULL — PRI
  • Key (id2) — bigint — Foreign key → Untitled.Key — NOT NULL — PRI
  • Key (uid) — bigint — Foreign key → Untitled.Key — NOT NULL — MUL
  • refreshToken (createdAt) — datetime(6)
  • userImage (createdBy) — varchar(255)
  • Field (stat) — varchar(255)
  • Field (updatedAt) — datetime(6)
  • Field (updatedBy) — varchar(255)
  • Field (token) — varchar(255)
  • Field (tokenKey) — varchar(255)
  • Field (type) — varchar(255) — MUL

Untitled (cm_user)

  • Key (id) — bigint — Primary key — NOT NULL — PRI
  • Field (createdAt) — datetime(6)
  • Field (createdBy) — varchar(255)
  • Field (stat) — varchar(255)
  • Field (updatedAt) — datetime(6)
  • Field (updatedBy) — varchar(255)
  • Field (addrCode) — varchar(255)
  • Field (addrDetail) — varchar(255)
  • Field (addrText) — varchar(255)
  • Field (birthDate) — datetime(6)
  • Field (email) — varchar(255)
  • Field (gids) — varchar(255)
  • Field (name) — varchar(255)
  • Field (password) — varchar(255)
  • Field (phone) — varchar(255)
  • Field (photo) — varchar(255)
  • Field (roles) — varchar(255)
  • Field (type) — varchar(255)
  • Field (username) — varchar(255) — UNI

Untitled (cm_user_setting)

  • Key (uid) — bigint — Primary key — NOT NULL — PRI
  • Field (createdAt) — datetime(6)
  • Field (createdBy) — varchar(255)
  • Field (stat) — varchar(255)
  • Field (updatedAt) — datetime(6)
  • Field (updatedBy) — varchar(255)
  • Field (isAdOn) — bit(1)
  • Field (isEventNotiOn) — bit(1)
  • Field (isLocOn) — bit(1)
  • Field (isNoticeNotiOn) — bit(1)
  • Field (isPayNotiOn) — bit(1)
  • Field (isShopNotiOn) — bit(1)
  • Field (isWashNotiOn) — bit(1)

Untitled (cm_spot)

  • Key (id) — bigint — Primary key — NOT NULL — PRI
  • Field (createdAt) — datetime(6)
  • Field (createdBy) — varchar(255)
  • Field (stat) — varchar(255)
  • Field (updatedAt) — datetime(6)
  • Field (updatedBy) — varchar(255)
  • Field (accessFlag) — int
  • Field (gid) — bigint
  • Field (ownerId) — bigint
  • Field (ownerName) — varchar(255)
  • Field (kind) — varchar(255)
  • Field (loc1) — varchar(255)
  • Field (loc2) — varchar(255)
  • Field (loc3) — varchar(255)
  • Field (note) — varchar(255)
  • Field (regAt) — datetime(6)
  • Field (title) — varchar(255) — MUL
  • Field (type) — varchar(255)
  • Field (lati) — float — MUL
  • Field (lngi) — float