Testcases
Tables (8)
bug_reports
- bug_id — VARCHAR(64) — Primary key — NOT NULL
- item_id — VARCHAR(64) — Foreign key → items.item_id
- build_id — SERIAL — Foreign key → game_builds.build_id — NOT NULL
- severity — VARCHAR(32) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- reported_by — VARCHAR(64) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- created_at — TIMESTAMP
game_builds
- build_id — SERIAL — Primary key — NOT NULL
- version_tag — VARCHAR(64) — NOT NULL
- released_at — DATE
item_categories
- category_id — SERIAL — Primary key — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- parent_id — INT — Foreign key → item_categories.category_id
- description — TEXT
item_test_matrix
- matrix_id — SERIAL — Primary key — NOT NULL
- item_id — VARCHAR(64) — Foreign key → items.item_id — NOT NULL
- test_case_id — VARCHAR(64) — Foreign key → test_cases.test_case_id — NOT NULL
- is_applicable — BOOLEAN
- override_notes — TEXT
items
- item_id — VARCHAR(64) — Primary key — NOT NULL
- item_name — VARCHAR(255) — NOT NULL
- category_id — INT — Foreign key → item_categories.category_id — NOT NULL
- rarity — VARCHAR(32) — NOT NULL
- max_stack_size — INT — NOT NULL
- is_tradable — BOOLEAN — NOT NULL
- is_droppable — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- updated_at — TIMESTAMP
test_cases
- test_case_id — VARCHAR(64) — Primary key — NOT NULL
- suite_id — INT — Foreign key → test_suites.suite_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- test_type — VARCHAR(64) — NOT NULL
- priority — VARCHAR(10) — NOT NULL
- is_generic_template — BOOLEAN — NOT NULL
- preconditions — TEXT
- updated_at — TIMESTAMP
test_steps
- step_id — SERIAL — Primary key — NOT NULL
- test_case_id — VARCHAR(64) — Foreign key → test_cases.test_case_id — NOT NULL
- step_number — INT — NOT NULL
- action_description — TEXT — NOT NULL
test_suites
- suite_id — VARCHAR(32) — Primary key — NOT NULL
- suite_name — VARCHAR(255) — NOT NULL
- description — TEXT