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