hey young please
Tables (10)
Untitled (Point_history)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- Key (survey_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (amount) — INT — NOT NULL
- Field (transferred_at) — TIMESTAMP — NOT NULL
Untitled (Survey)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- Field (title) — VARCHAR(255) — NOT NULL
- Field (description) — TEXT
- Field (filter_school) — ENUM — NOT NULL
- Field (filter_grade) — ENUM
- Field (filter_major) — VARCHAR(100)
- Field (filter_age) — INT
- Field (filter_gender) — ENUM
- Field (filter_mydata_category) — ENUM
- Field (filter_mydata_consume_degree) — VARCHAR(100)
- Field (filter_mydata_consume_amount) — INT
- Field (lottery_quota) — INT
- Field (lottery_head_count) — INT
- Field (first_come_quota) — INT
- Field (first_come_head_count) — INT
- Field (start_date) — TIMESTAMP — NOT NULL
- Field (end_date) — TIMESTAMP — NOT NULL
- Field (active) — ENUM — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP — NOT NULL
Untitled (Question)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (survey_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (order_index) — INT — NOT NULL
- Field (question_text) — TEXT — NOT NULL
- Field (question_type) — ENUM — NOT NULL
- Field (is_required) — BOOLEAN — NOT NULL
- Field (options) — JSON
- Field (random_check_answer) — INT
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP — NOT NULL
Untitled (Survey_participants)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- Key (survey_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (is_first) — BOOLEAN — NOT NULL
- Field (is_winner) — BOOLEAN
- Field (is_random_check_passed) — BOOLEAN — NOT NULL
- Field (submitted_at) — TIMESTAMP — NOT NULL
Untitled (Question_answers)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- Key (question_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (contents) — TEXT
- Field (created_at) — TIMESTAMP — NOT NULL
Untitled (Survey_report)
- Key (survey_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- Field (contents) — TEXT — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
Untitled (Virtual_account)
- Key (survey_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (account_number) — VARCHAR(50) — NOT NULL
- Field (expected_amount) — INT — NOT NULL
- Field (status) — ENUM — NOT NULL
- Field (created_at) — TIMESTAMP
- Field (deposited_at) — TIMESTAMP — NOT NULL
Untitled (Survey_point_pool)
- Key (survey_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (total_amount) — INT — NOT NULL
- Field (used_amount) — INT — NOT NULL
- Field (remaining_amount) — INT — NOT NULL
- Field (status) — ENUM — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP — NOT NULL
Untitled (Mydata_consumption_summary)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- Field (date) — TIMESTAMP — NOT NULL
- Field (main_category) — VARCHAR(50) — NOT NULL
- Field (sub_category) — VARCHAR(50) — NOT NULL
- Field (spent_amount) — DECIMAL(12,2) — NOT NULL
- Field (transaction_count) — INT — NOT NULL
User
- id — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (student_number) — VARCHAR(50) — NOT NULL
- Field (school) — VARCHAR(50) — NOT NULL
- Field (account) — VARCHAR(50)
- Field (mypoint) — INT — NOT NULL
- Field (mydata_agree) — BOOLEAN — NOT NULL