{
  "name": "敦煌飞天·数字壁画",
  "blockchain": "antchain",
  "token_standard": "ERC-721",
  "total_supply": 10000,
  "price": 29.90,
  "currency": "CNY",
  "sale_start": "2024-08-01T10:00:00Z",
  "sale_type": "flash_sale",
  "purchase_limit": { "kyc_level": "L2", "max_per_user": 2 },
  "royalty_rate": 0.05,
  "cover_url": "https://cdn.example.com/dunhuang.jpg"
}

{
  "client_id": "platform_app_001",
  "redirect_uri": "https://platform.com/oauth/callback",
  "scope": "user:info collection:read order:read",
  "response_type": "code",
  "state": "random_csrf_token"
}

GET /api/v1/market/collections?address={wallet}
Headers:
  Authorization: Bearer {access_token}
  X-Platform-Key: {platform_key}

Response:
{
  "collections": [
    {
      "token_id": "12345",
      "name": "敦煌飞天",
      "market_url": "https://market.example/item/12345",
      "last_trade_price": 299,
      "royalty_rate": 0.05
    }
  ]
}

-- 用户表
CREATE TABLE users (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  phone VARCHAR(20) UNIQUE,
  email VARCHAR(100) UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  nickname VARCHAR(50),
  avatar_url VARCHAR(500),
  kyc_level TINYINT DEFAULT 0,
  kyc_status TINYINT DEFAULT 0,
  real_name_encrypted VARCHAR(500),
  id_card_encrypted VARCHAR(500),
  status TINYINT DEFAULT 1,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX idx_phone (phone), INDEX idx_kyc_level (kyc_level)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 藏品表
CREATE TABLE collections (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  issue_id BIGINT NOT NULL,
  token_id VARCHAR(100),
  blockchain VARCHAR(20),
  token_standard VARCHAR(20),
  owner_user_id BIGINT NOT NULL,
  name VARCHAR(200) NOT NULL,
  description TEXT,
  cover_url VARCHAR(500),
  rarity VARCHAR(20),
  metadata_url VARCHAR(500),
  minted_at DATETIME,
  status TINYINT DEFAULT 1,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_issue (issue_id), INDEX idx_owner (owner_user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 发行计划表
CREATE TABLE issues (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  issuer_id BIGINT NOT NULL,
  name VARCHAR(200) NOT NULL,
  blockchain VARCHAR(20) NOT NULL,
  total_supply INT NOT NULL,
  remaining_supply INT NOT NULL,
  price DECIMAL(10,2) NOT NULL,
  currency VARCHAR(10) DEFAULT 'CNY',
  sale_type VARCHAR(20),
  sale_start DATETIME, sale_end DATETIME,
  kyc_level_required TINYINT DEFAULT 1,
  purchase_limit INT DEFAULT 1,
  status TINYINT DEFAULT 0,
  royalty_rate DECIMAL(5,4) DEFAULT 0.05,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX idx_issuer (issuer_id), INDEX idx_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 订单表
CREATE TABLE orders (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  order_no VARCHAR(64) UNIQUE NOT NULL,
  user_id BIGINT NOT NULL, issue_id BIGINT NOT NULL,
  collection_id BIGINT,
  quantity INT DEFAULT 1,
  amount DECIMAL(10,2) NOT NULL,
  currency VARCHAR(10) DEFAULT 'CNY',
  payment_method VARCHAR(20),
  payment_no VARCHAR(128),
  status VARCHAR(20) DEFAULT 'pending',
  paid_at DATETIME,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX idx_user (user_id), INDEX idx_order_no (order_no)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 发行方表
CREATE TABLE issuers (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(200) NOT NULL,
  logo_url VARCHAR(500),
  contact_email VARCHAR(100),
  business_license_url VARCHAR(500),
  revenue_share_rate DECIMAL(5,4) DEFAULT 0.80,
  status TINYINT DEFAULT 0,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;