okayapi_guanggaobao_bid_detail - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_guanggaobao_bid_detail：/tablelist/okayapi_guanggaobao_bid_detail.html


-- MySQL Table okayapi_guanggaobao_bid_detail
-- From: OkayAPI.com
CREATE TABLE `okayapi_guanggaobao_bid_detail` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `demand_id` int(11) NULL COMMENT '竞价项目编号',
    `bider_id` int(11) NULL COMMENT '报价人编号',
    `bid_price` decimal(11,0) NULL COMMENT '报价',
    `create_time` int(11) NULL COMMENT '创建时间',
    `okayapi_guanggaobao_bid_detail_status` int(2) NULL COMMENT '状态值',
    KEY `demand_id` (`demand_id`),
    KEY `bider_id` (`bider_id`),
    KEY `bid_price` (`bid_price`),
    KEY `create_time` (`create_time`),
    KEY `okayapi_guanggaobao_bid_detail_status` (`okayapi_guanggaobao_bid_detail_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '广告宝-竞价详情表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-5 of 5 results.

Field Name	Field Type	IS NULL	Field Comment
demand_id	int(11)	否	竞价项目编号
bider_id	int(11)	否	报价人编号
bid_price	decimal(11,0)	是	报价
create_time	int(11)	是	创建时间
okayapi_guanggaobao_bid_detail_status	int(2)	是	状态值