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