Design a complete users table combining all data type knowledge

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Problem

Design a complete users table combining all data type knowledge. Choose the most appropriate type for each attribute: BIGINT for IDs, VARCHAR for bounded text, TIMESTAMP for moments, BOOLEAN for flags, and JSON for flexible data.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.