123
Tables (9)
applies
- id — INT — Primary key — NOT NULL
- applyState — VARCHAR(40) — NOT NULL
- transactionHash — VARCHAR(200)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- memberId — INT — NOT NULL
- competitionId — INT — NOT NULL
- INDEX — `memberId`
- INDEX — `competitionId`
auth_codes
- id — INT — Primary key — NOT NULL
- phoneNumber — VARCHAR(40) — NOT NULL
- authCode — VARCHAR(6) — NOT NULL
- status — VARCHAR(10)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
code_use_logs
- id — INT — Primary key — NOT NULL
- code — VARCHAR(40) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- memberId — INT — NOT NULL
- INDEX — `memberId`
codes
- id — INT — Primary key — NOT NULL
- code — VARCHAR(40) — NOT NULL
- useYn — TINYINT(1)
- useDate — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- memberId — INT
- INDEX — `memberId`
competitions
- id — INT — Primary key — NOT NULL
- competitionDate — VARCHAR(20) — NOT NULL
- competitionStart — VARCHAR(4)
- competitionType — VARCHAR(40) — NOT NULL
- maxApply — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- placeId — INT — NOT NULL
- status — VARCHAR(20)
- INDEX — `placeId`
members
- id — INT — Primary key — NOT NULL
- userId — VARCHAR(200) — NOT NULL
- passwd — VARCHAR(500) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nick — VARCHAR(50) — NOT NULL
- date — VARCHAR(8) — NOT NULL
- phoneNumber — VARCHAR(30) — NOT NULL
- walletAddress — VARCHAR(200)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- type — VARCHAR(20)
places
- id — INT — Primary key — NOT NULL
- placeCode — VARCHAR(40) — NOT NULL
- placeName — VARCHAR(40) — NOT NULL
- placeTel1 — VARCHAR(40)
- placeTel2 — VARCHAR(40)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
sms_detail_logs
- id — INT — Primary key — NOT NULL
- phoneNumber — VARCHAR(20) — NOT NULL
- detail — VARCHAR(2000) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- smsLogId — INT — NOT NULL
- INDEX — `smsLogId`
sms_logs
- id — INT — Primary key — NOT NULL
- contents — VARCHAR(400) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL