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