Test
Tables (17)
Address
- address_id — INT
- street_address — VARCHAR(255)
- city — VARCHAR(100)
- state — VARCHAR(50)
- postal_code — VARCHAR(20)
- country — VARCHAR(50)
AddressServiceRegion
- address_region_id — INT
- address_id — INT — NOT NULL
- region_id — INT — NOT NULL
- created_at — TIMESTAMP
Category
- category_id — INT
- category_name — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
ContentPolicy
- policy_id — INT
- policy_name — VARCHAR(100) — NOT NULL
- policy_description — TEXT
- is_active — BOOLEAN
- created_at — TIMESTAMP
EventLog
- event_id — INT
- user_id — INT
- post_id — INT
- event_type — VARCHAR(50)
- event_data — JSON
- ip_address — VARCHAR(45)
- created_at — TIMESTAMP
GeoLocation
- geo_id — INT
- latitude — DECIMAL(10, 8)
- longitude — DECIMAL(11, 8)
- region_id — INT
- address — VARCHAR(255)
Like
- like_id — INT
- user_id — INT — NOT NULL
- post_id — INT — NOT NULL
- created_at — TIMESTAMP
POST
- post_id — INT
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- user_id — INT — NOT NULL
- category_id — INT
- region_id — INT
- geo_id — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_active — BOOLEAN
PostCategory
- post_category_id — INT
- post_id — INT — NOT NULL
- category_id — INT — NOT NULL
- assigned_at — TIMESTAMP
RegionContent
- region_content_id — INT
- region_id — INT — NOT NULL
- content_type — VARCHAR(50)
- content_data — TEXT
- created_at — TIMESTAMP
ServiceRegion
- region_id — INT
- region_name — VARCHAR(100) — NOT NULL
- region_code — VARCHAR(10)
- is_active — BOOLEAN
StreamingEndpoint
- endpoint_id — INT
- endpoint_url — VARCHAR(500) — NOT NULL
- region_id — INT
- is_active — BOOLEAN
- created_at — TIMESTAMP
StreamingLog
- log_id — INT
- user_id — INT
- endpoint_id — INT
- video_id — INT
- action — VARCHAR(50)
- timestamp_start — TIMESTAMP
- timestamp_end — TIMESTAMP
- bytes_transferred — BIGINT
- created_at — TIMESTAMP
User
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
UserAddress
- user_address_id — INT
- user_id — INT — NOT NULL
- address_id — INT — NOT NULL
- address_type — ENUM('home', 'work', 'billing', 'shipping')
- is_primary — BOOLEAN
- created_at — TIMESTAMP
UserServiceRegion
- user_region_id — INT
- user_id — INT — NOT NULL
- region_id — INT — NOT NULL
- created_at — TIMESTAMP
VIDEO
- video_id — INT
- post_id — INT — NOT NULL
- video_url — VARCHAR(500)
- video_title — VARCHAR(200)
- duration — INT
- file_size — BIGINT
- uploaded_at — TIMESTAMP