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