UnderFaker
Tables (8)
api_sync_log
- sync_id — BIGINT — Primary key — NOT NULL
- admin_id — BIGINT — Foreign key → user.user_id — NOT NULL
- api_type — ENUM('RECALL','CERT')
- result_code — VARCHAR(10)
- record_count — INT
- started_at — DATETIME
- finished_at — DATETIME
certification
- cert_uid — BIGINT — Primary key — NOT NULL
- cert_num — VARCHAR(64)
- cert_state — VARCHAR(100)
- cert_date — CHAR(8)
- product_name — VARCHAR(255)
- brand_name — VARCHAR(255)
- model_name — VARCHAR(255)
- maker_name — VARCHAR(255)
- maker_cntry_name — VARCHAR(255)
- synced_at — DATETIME
extraction
- extraction_id — BIGINT — Primary key — NOT NULL
- verification_id — BIGINT — Foreign key → verification.verification_id — NOT NULL
- source — ENUM('URL','IMAGE','MANUAL')
- product_name — VARCHAR(255)
- brand_name — VARCHAR(255)
- model_name — VARCHAR(255)
- maker_name — VARCHAR(255)
- barcode_num — VARCHAR(64)
- cert_num — VARCHAR(64)
- raw_text — TEXT
- confidence — DOUBLE
- created_at — DATETIME
match_result
- match_id — BIGINT — Primary key — NOT NULL
- verification_id — BIGINT — Foreign key → verification.verification_id — NOT NULL
- recall_uid — BIGINT — Foreign key → recall.recall_uid — NOT NULL
- similarity_score — DOUBLE
- matched_field — VARCHAR(255)
- decision — ENUM('MATCH','PARTIAL','NO_MATCH')
- reason — VARCHAR(1000)
- created_at — DATETIME
recall
- recall_uid — BIGINT — Primary key — NOT NULL
- recall_product_name — VARCHAR(255)
- recall_brand_name — VARCHAR(255)
- recall_model_name — VARCHAR(1000)
- recall_model_cnt — INT
- barcode_num — VARCHAR(64)
- cert_num — VARCHAR(255)
- category_name — VARCHAR(255)
- recall_type_name — VARCHAR(100)
- recall_means — VARCHAR(255)
- recall_cmpny_name — VARCHAR(255)
- maker_name — VARCHAR(255)
- making_cntry_name — VARCHAR(255)
- publish_date — CHAR(8)
- harm_dscr — TEXT
- accident_case_dscr — TEXT
- publish_action_dscr — TEXT
- synced_at — DATETIME
recall_file
- recall_file_id — BIGINT — Primary key — NOT NULL
- recall_uid — BIGINT — Foreign key → recall.recall_uid — NOT NULL
- file_div — ENUM('전체사진','부분사진')
- image_url — VARCHAR(512)
user
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- username — VARCHAR(100)
- user_role — ENUM('USER','ADMIN')
- created_at — DATETIME
- updated_at — DATETIME
verification
- verification_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- input_type — ENUM('URL','IMAGE','MANUAL')
- input_url — VARCHAR(1000)
- image_path — VARCHAR(512)
- status — ENUM('PENDING','DONE','FAILED')
- final_result — ENUM('MATCH','PARTIAL','NO_MATCH','UNKNOWN')
- created_at — DATETIME
- updated_at — DATETIME