🗄️ 数据库ER关系图

erDiagram users ||--o{ event_registrations : "报名" users ||--o{ orders : "下单" users ||--o{ user_addresses : "拥有" users ||--o{ user_bills : "产生" users ||--o{ user_dynamics : "发布" users ||--o{ user_verify : "认证" events ||--o{ event_groups : "包含" events ||--o{ event_registrations : "被报名" events ||--o{ event_announcements : "有公告" events ||--o{ event_dynamics : "关联" event_groups ||--o{ race_results : "产生" event_groups ||--o{ start_lists : "生成" event_groups ||--o{ event_registrations : "分组" drivers ||--o{ race_results : "参赛" drivers ||--o{ start_lists : "发车" drivers ||--o{ event_registrations : "报名" teams ||--o{ drivers : "包含" products ||--o{ product_specs : "有规格" products ||--o{ order_items : "被购买" orders ||--o{ order_items : "包含" orders }o--|| user_addresses : "使用" users { int id PK string openid UK string nickname string avatar_url string phone decimal balance_coins int verify_status datetime created_at datetime updated_at } events { int id PK string title date start_date date end_date string location string contact_name string contact_phone string contact_wechat date reg_deadline enum status text description string cover_image int view_count datetime created_at } event_groups { int id PK int event_id FK string name datetime race_date enum status int max_participants decimal reg_price int coins_reward } event_registrations { int id PK int user_id FK int event_id FK int group_id FK int driver_id FK string round_name enum status decimal paid_amount datetime paid_at datetime created_at } drivers { int id PK string name int team_id FK string car_number string photo datetime created_at } teams { int id PK string name string logo datetime created_at } race_results { int id PK int group_id FK int driver_id FK int rank string total_time string race_time string penalty_time text penalty_details datetime created_at } start_lists { int id PK int group_id FK int driver_id FK int lane_number int sort_order datetime created_at } products { int id PK string title text description string category json images decimal min_price decimal max_price int min_coins_reward int max_coins_reward int stock int sales_count enum status datetime created_at } product_specs { int id PK int product_id FK string spec_name decimal price int coins_reward int stock datetime created_at } orders { int id PK int user_id FK string order_no UK decimal total_amount int coins_used int coins_reward int address_id FK enum status string logistics_company string logistics_no datetime paid_at datetime shipped_at datetime completed_at datetime created_at } order_items { int id PK int order_id FK int product_id FK int spec_id FK int quantity decimal price_snapshot int coins_reward_snapshot } user_addresses { int id PK int user_id FK string name string phone string province string city string district string street string postal_code boolean is_default datetime created_at } user_bills { int id PK int user_id FK enum type enum source_type int source_id int coins_change int coins_balance string description datetime created_at } user_dynamics { int id PK int user_id FK int event_id FK string content json media_urls int like_count int comment_count enum status datetime created_at } user_verify { int id PK int user_id FK string real_name string id_card json id_card_images enum status string reject_reason datetime verified_at datetime created_at } event_announcements { int id PK int event_id FK string title text content int sort_order datetime created_at } event_dynamics { int id PK int event_id FK int user_id FK string content json media_urls datetime created_at }