bareun
Tables (6)
Auth
- authId — INT
- userId — INT — NOT NULL
- token — VARCHAR(500) — NOT NULL
- createdAt — DATETIME
- expiredAt — DATETIME
Inquiries
- inquiryId — INT
- userId — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('pending', 'answered')
- adminReply — TEXT
- createdAt — DATETIME
- updatedAt — DATETIME
Notifications
- notificationId — INT
- userId — INT — NOT NULL
- preferredTime — TIME — NOT NULL
- enabled — BOOLEAN
- createdAt — DATETIME
- updatedAt — DATETIME
Records
- recordId — INT
- userId — INT — NOT NULL
- postureImage — VARCHAR(255)
- badPostureCount — INT
- createdAt — DATETIME
- updatedAt — DATETIME
Reports
- reportId — INT
- userId — INT — NOT NULL
- reportType — ENUM('daily', 'weekly') — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
Users
- userId — INT
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('user', 'admin')
- profileImage — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME