test
Tables (7)
Admin
- admin_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
Board
- post_id — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- created_date — DATE
ExperienceHistory
- history_id — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- date — DATE — NOT NULL
- description — TEXT
- points — INT
- year — YEAR
Notifications
- notification_id — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- type — VARCHAR(50)
- message — TEXT
- date — DATE
QuestProgress
- progress_id — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- quest_id — VARCHAR(50) — NOT NULL
- date — DATE
- status — VARCHAR(50)
Quests
- quest_id — VARCHAR(50) — NOT NULL
- quest_type — VARCHAR(50)
- quest_name — VARCHAR(100) — NOT NULL
- frequency — VARCHAR(50)
- max_points — INT
- median_points — INT
- description — TEXT
Users
- user_id — VARCHAR(50) — NOT NULL
- employee_number — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- character — VARCHAR(255)
- password — VARCHAR(255) — NOT NULL
- level — INT
- join_date — DATE — NOT NULL
- experience_points — INT
- experience_this_year — INT
- is_admin — BOOLEAN