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