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