MCP

Tables (7)

category_large

  • large_category_id — BIGINT
  • large_category_name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

category_medium

  • medium_category_id — BIGINT
  • medium_category_name — VARCHAR(255) — NOT NULL
  • large_category_id — BIGINT — Foreign key → category_large.large_category_id — NOT NULL
  • created_at — TIMESTAMP

category_small

  • small_category_id — BIGINT
  • product_name — VARCHAR(255) — NOT NULL
  • large_category_id — BIGINT — Foreign key → category_large.large_category_id — NOT NULL
  • medium_category_id — BIGINT — Foreign key → category_medium.medium_category_id — NOT NULL
  • created_at — TIMESTAMP

file_detail

  • file_detail_id — BIGINT
  • file_path — VARCHAR(500) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • origin_file_name — VARCHAR(255)
  • extension — VARCHAR(20)
  • file_size — BIGINT
  • file_master_id — BIGINT — Foreign key → file_master.file_master_id — NOT NULL

file_master

  • file_master_id — BIGINT
  • category — ENUM( 'ITEM_COLUMN', 'ITEM_DATA', 'ITEM_DOWNLOAD_REPORT' ) — NOT NULL

item_column

  • column_id — BIGINT
  • column_name — VARCHAR(255) — NOT NULL
  • column_type — ENUM( 'TEXT', 'NUMBER', 'DATE', 'FILE' )
  • medium_category_id — BIGINT — Foreign key → category_medium.medium_category_id — NOT NULL
  • file_master_id — BIGINT — Foreign key → file_master.file_master_id
  • created_at — TIMESTAMP

item_data

  • data_id — BIGINT
  • small_category_id — BIGINT — Foreign key → category_small.small_category_id — NOT NULL
  • column_id — BIGINT — Foreign key → item_column.column_id — NOT NULL
  • data_value — TEXT
  • file_master_id — BIGINT — Foreign key → file_master.file_master_id
  • created_at — TIMESTAMP