okayapi_dberp_accounts_receivable_log - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_dberp_accounts_receivable_log：/tablelist/okayapi_dberp_accounts_receivable_log.html


-- MySQL Table okayapi_dberp_accounts_receivable_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_accounts_receivable_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `receivable_id` int(11) NOT NULL COMMENT '',
    `receivable_log_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `receivable_log_user` varchar(100) NOT NULL COMMENT '',
    `receivable_log_time` int(10) NOT NULL COMMENT '',
    `receivable_file` varchar(255) NOT NULL COMMENT '',
    `receivable_info` varchar(255) NOT NULL COMMENT '',
    `receivable_add_time` int(10) NOT NULL COMMENT '',
    `admin_id` int(11) NOT NULL COMMENT '',
    KEY `receivable_id` (`receivable_id`),
    KEY `receivable_log_amount` (`receivable_log_amount`),
    KEY `receivable_log_user` (`receivable_log_user`),
    KEY `receivable_log_time` (`receivable_log_time`),
    KEY `receivable_file` (`receivable_file`),
    KEY `receivable_info` (`receivable_info`),
    KEY `receivable_add_time` (`receivable_add_time`),
    KEY `admin_id` (`admin_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'DBErp进销存-收款记录';

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

MySQL database table structure design

Displaying 1-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Demo Data
receivable_id	int(11)		否
receivable_log_amount	decimal(19,4)	0.0000	否	0.0000
receivable_log_user	varchar(100)		否
receivable_log_time	int(10)		否
receivable_file	varchar(255)		是
receivable_info	varchar(255)		是
receivable_add_time	int(10)		否
admin_id	int(11)		否