后台管理

审核、寄售、仲裁、放款和词表维护。

事项	类型	用户	状态	优先级
饭制贴纸包需确认非官方标记	listing_review	sundaylab	待审核	normal
Star Road 套装入库验货	consignment	bluehour	仓库待拍照	high
订单 ORD-2048 超时确认放款	payout	allyz-rose	可放款	normal
重复盗图举报	report	mintcard	待仲裁	urgent

Supabase schema preview


create table profiles (
  id uuid primary key references auth.users(id),
  display_name text not null,
  locale text default 'zh-CN',
  region text,
  seller_rating numeric default 0,
  is_admin boolean default false
);

create table members (
  id text primary key,
  name text not null,
  cn_name text not null,
  featured boolean default false
);

create table listings (
  id uuid primary key default gen_random_uuid(),
  seller_id uuid not null references profiles(id),
  member_id text not null references members(id),
  title text not null,
  category text not null,
  era text,
  version text,
  condition text not null,
  official boolean not null,
  fulfillment text check (fulfillment in ('seller_ship', 'consignment')),
  status text not null default 'pending_review',
  price numeric not null,
  currency text not null check (currency in ('CNY', 'USD')),
  origin text,
  created_at timestamptz default now()
);

create table orders (
  id uuid primary key default gen_random_uuid(),
  listing_id uuid not null references listings(id),
  buyer_id uuid not null references profiles(id),
  seller_id uuid not null references profiles(id),
  status text not null default 'pending_payment',
  amount numeric not null,
  currency text not null,
  platform_fee numeric not null,
  created_at timestamptz default now()
);

create table watchlists (
  id uuid primary key default gen_random_uuid(),
  user_id uuid not null references profiles(id),
  member_id text references members(id),
  category text,
  max_price numeric,
  currency text,
  alert_type text not null
);