Coblox

Tables (12)

Comment (comment)

  • Comment ID (comment_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key
  • User ID (user_id) — CHAR(11) — Foreign key → User Info.User ID — NOT NULL
  • Product Id (product_id) — INT UNSIGNED — Foreign key → Product.Product Id — NOT NULL
  • Comment (comment) — VARCHAR(300) — NOT NULL
  • Published at (published_at) — DATETIME — NOT NULL

Comment Like (comment_likes)

  • Comment ID (comment_id) — INT UNSIGNED — Foreign key → Comment.Comment ID — NOT NULL
  • User ID (user_id) — CHAR(11) — Foreign key → User Info.User ID — NOT NULL

Product (product)

  • Product Id (product_id) — INT UNSIGNED — Primary key — NOT NULL
  • Area (area) — TINYINT UNSIGNED — NOT NULL
  • Team Photo (team_photo) — VARCHAR(2048) — NOT NULL
  • Product Photo (product_photo) — VARCHAR(2048) — NOT NULL
  • Showcase Photo (showcase_photo) — VARCHAR(2048) — NOT NULL
  • Description (description) — VARCHAR(400) — NOT NULL
  • Used Tech Stack (used_tech_stack) — VARCHAR(200) — NOT NULL
  • Reflection (reflection) — VARCHAR(400) — NOT NULL

Stamp (stamp)

  • Stamp ID (stamp_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key
  • User ID (user_id) — CHAR(11) — Foreign key → User Info.User ID — NOT NULL
  • Product Id (product_id) — INT UNSIGNED — Foreign key → Product.Product Id — NOT NULL
  • Completed at (completed_at) — DATETIME — NOT NULL

Survey (survey)

  • Survey ID (survey_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key
  • Title (title) — VARCHAR(100) — NOT NULL

Survey Answer (survey_answer)

  • Survey Answer ID (survey_answer_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key
  • User ID (user_id) — CHAR(11) — Foreign key → User Info.User ID — NOT NULL
  • Survey ID (survey_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Foreign key → Survey.Survey ID
  • Survey Question ID (survey_question_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Foreign key → Survey Question.Survey Question ID
  • Answer (answer) — JSON

Survey Complete (survey_complete)

  • Survey Complete ID (survey_complete_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key
  • Survey ID (survey_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Foreign key → Survey.Survey ID
  • User ID (user_id) — CHAR(11) — Foreign key → User Info.User ID — NOT NULL
  • Completed at (completed_at) — DATETIME — NOT NULL

Survey Question (survey_question)

  • Survey Question ID (survey_question_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key
  • Survey ID (survey_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Foreign key → Survey.Survey ID
  • Question Title (title) — VARCHAR(100)
  • Answer Type (answer_type) — TINYINT UNSIGNED
  • Question (question) — JSON

User Info (user)

  • User ID (user_id) — CHAR(11) — Primary key — NOT NULL
  • User PW (user_pw) — CHAR(32) — NOT NULL
  • User Role (role) — TINYINT UNSIGNED — NOT NULL
  • Agree Privacy Policy (agree_privacy_policy) — BOOLEAN — NOT NULL
  • Nickname (nickname) — CHAR(24) — NOT NULL
  • Nickname Change (allowed_nickname_changes) — TINYINT UNSIGNED — NOT NULL
  • Create at (created_at) — DATETIME — NOT NULL
  • Device (device) — CHAR(24) — NOT NULL
  • Account Address (account_address) — CHAR(42) — NOT NULL
  • Private Key (private_key) — CHAR(66) — NOT NULL
  • Student No (student_no) — CHAR(10) — NOT NULL
  • Name (name) — CHAR(5) — NOT NULL

User Product (user_product)

  • User ID (user_id) — CHAR(11) — Foreign key → User Info.User ID — NOT NULL
  • Product Id (product_id) — INT UNSIGNED — Foreign key → Product.Product Id — NOT NULL

User Vote (vote)

  • Vote ID (vote_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key
  • User ID (user_id) — CHAR(11) — Foreign key → User Info.User ID — NOT NULL
  • Product Id (product_id) — INT UNSIGNED — Foreign key → Product.Product Id — NOT NULL
  • Award Type (award_type) — TINYINT UNSIGNED — NOT NULL
  • X Coord (coord_x) — DOUBLE — NOT NULL
  • Y Coord (coord_y) — DOUBLE — NOT NULL
  • Sticker Type (sticker_type) — TINYINT UNSIGNED — NOT NULL
  • Voted at (voted_at) — DATETIME — NOT NULL

User Vote Rights (vote_rights)

  • Vote Rights ID (vote_rights_id) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key
  • User ID (user_id) — CHAR(11) — Foreign key → User Info.User ID — NOT NULL
  • Award Type (award_type) — TINYINT UNSIGNED — NOT NULL
  • Granted at (granted_at) — DATETIME — NOT NULL
  • Available Votes (available_votes) — INT UNSIGNED — NOT NULL
  • Total Votes Received (total_votes_received) — INT UNSIGNED — NOT NULL