下载文档原格式
数据库表描述-概述说明以及解释1.引言1.1 概述在数据库管理系统中，表是一种结构化的数据存储单元，它由行和列组成，用于存储具有相似特性的数据。
数据库表描述着整个数据库的结构和关系，是数据存储和管理的基本单位之一。
通过对数据库表的描述，我们可以清晰地了解数据的组织结构，实现数据的高效存储和管理。
在本文中，我们将介绍数据库表的定义、作用以及相关的设计原则，以帮助读者深入了解数据库表的重要性和设计要点。
通过本文的学习，读者将能够更好地理解和应用数据库表，提高数据库系统的性能和可维护性。
1.2文章结构文章结构部分主要包括本文的组织结构和内容安排。
在本文中，我们将分为引言、正文和结论三个部分来介绍数据库表的描述。
在引言部分，我们会概述本文的主题，介绍数据库表描述的重要性和背景，以及本文的目的和结构。
在正文部分，我们将详细讨论数据库表的定义、作用、组成要素和设计原则，从而帮助读者深入了解数据库表的概念和特点。
在结论部分，我们会总结数据库表描述的重要性，强调数据库表设计的关键因素，并对数据库表描述的未来发展进行展望。
通过全面地介绍数据库表的描述和设计原则，我们希望读者可以更好地理解和应用数据库表，提高数据管理和存储的效率和质量。
1.3 目的在数据库系统中，数据库表描述是非常重要的。
它可以帮助开发人员更好地了解数据库表的结构和功能，帮助维护人员更好地管理和维护数据库表，帮助用户更好地理解数据库表中存储的数据。
因此，本文的目的是通过对数据库表描述的介绍，帮助读者了解数据库表的重要性和作用，掌握数据库表的基本概念和设计原则，以提高数据库表设计的质量和效率。
同时，希望通过本文的讨论，引发对数据库表描述的思考和讨论，推动数据库表描述在未来的进一步发展和应用。
2.正文2.1 数据库表的定义和作用数据库表是数据库中的一个重要组成部分，它是用来存储数据的结构化方式。
每个数据库表都包含了一定数量的行和列，行代表记录，列代表属性。
数据库表描述全文共四篇示例，供读者参考第一篇示例：数据库表是数据库系统中的基本组成单元，用来存储特定类型的数据。
它由行和列组成，行代表数据记录，列代表数据属性。
在数据库设计中，表的结构和字段类型需要经过精心设计，以确保数据的存储和检索效率。
本文将探讨数据库表的描述和设计方法。
一、数据库表的描述1. 表名：数据库表需要有一个唯一的名称来区分不同的表。
表名应该简洁明了，能够清晰地表达表所存储的数据类型。
一般来说，表名采用复数形式，并使用下划线或驼峰命名规则。
2. 字段（列）：数据库表由多个字段组成，每个字段代表数据的一个属性。
字段的命名应该具有描述性，能够清晰地表达该字段存储的数据内容。
常见的字段类型包括整型、字符型、日期型等。
3. 数据类型：字段的数据类型决定了字段可以存储的数据范围和格式。
常见的数据类型包括整型（INT）、字符型（VARCHAR）、日期型（DATE）等。
选择合适的数据类型可以提高数据库的存储效率和数据完整性。
4. 主键：主键是表中用来唯一标识每条记录的字段，通常是一个或多个字段的组合。
主键的值必须唯一且不能为空，可以通过主键索引来加快数据检索速度。
主键的选择应该遵循唯一性和稳定性原则。
5. 外键：外键是表与表之间建立关联关系的依据。
外键是指在一个表中存在的另一个表的主键，用来确保数据的一致性和完整性。
外键约束可以在数据库设计时设置，以确保引用表的数据不会出现错误或不一致。
6. 索引：索引是一种提高数据检索效率的数据结构，可以加速查询操作。
在数据库表中设置适当的索引可以减少搜索时间，并提高数据库的性能。
常见的索引类型包括主键索引、唯一索引、组合索引等。
7. 约束：约束是用来确保数据完整性和一致性的规则。
常见的约束包括主键约束、唯一约束、外键约束、默认值约束等。
在设计数据库表时，应该根据业务需求和数据关系来设置适当的约束。
二、数据库表的设计方法1. 标识表的对象：在设计数据库表时，首先需要确定要存储的数据对象和关系，然后根据需求来设计表的结构和字段。
如何用英语描述各种图表1、形种及归纳法：泛指一份数据表：a data graph(曲)/chart/diagram/illustration/table： pie chart直方或柱形：bar chart/histogram曲：line chart/curve diagram表格： table流程或程：flow chart/sequence diagram程序：processing/procedures diagram2、常用的描述用法The table/chart diagram/graph shows（ that）According to the table/chart diagram/graphAs （ is ） shown in the table/chart diagram/graphAs can be seen from the table/chart/diagram/graph/figures，）⋯⋯figures/statistics shows （ that It can beseen from the figures/statisticsWe can see from the figures/statisticsIt is clear from the figures/statisticsIt is apparent from the figures/statisticstable/chart/diagram/graph figures（that）⋯⋯table/chart/diagram/graph shows/describes/illustrates3、表中的数据（Data ）详尽表达法数据（ Data ）在某一个段固定不：fixed in time在一系列的段中：changes over time持化的data 在不一样样情况下：增加： increase/raise/rise/go up⋯⋯减少： decrease/grow down/drop/fall⋯⋯波： fluctuate/rebound/undulate/wave⋯⋯定： remain stable/stabilize/level off⋯⋯二、相关常用1、主章开表型： table （表格）、 chart （表）、 diagram （）、 graph （多指曲）、column chart （柱状）、pie graph（）、tree diagram（形）描述： show、describe、illustrate、can be seen from、clear、apparent、reveal、represent 内容： figure、statistic、number、percentage、proportion2、表示数据变化的单词也许词组rapid/rapidly迅速的，飞快的，峻峭的dramatic/dramatically戏剧性的，生动的significant/significantly有意义的，重要的，重要的sharp/sharply尖利的，明显的，急剧的steep/steeply急剧起落的steady/steadily坚固的，不卑不亢的gradual/gradually渐进的，逐渐的slow/slowly缓慢的，不活跃的slight/slightly略微的、略微地stable/stably坚固的3、其他在描述中的常用到的词significant changes图中一些较大变化noticeable trend明显趋势during the same period在同一时期grow/grew增distribute分布unequally不相等地in the case of在⋯⋯的情况下in terms of/in respect of/regarding在⋯⋯方面in contrast相反，大不一样样government policy政府政策market forces市力量measuren n. 尺寸，方法，措施v.预计，forecast n.先，v.猜三、表描述套句精table shows the changes in the number of⋯⋯over the period from⋯⋯to⋯⋯表格描述了在⋯⋯年之⋯⋯年⋯⋯数量的化。
表格描述类英语作文模板英文回答：Table Description Template。
Table Name。
Provide a brief and descriptive name for the table that accurately reflects its purpose and content.Table Purpose。
State the primary purpose of the table, indicating what it is intended to be used for.Table Structure。
Describe the structure of the table, including the number of rows and columns, as well as the data types and lengths of each column.Column Definitions。
Provide a detailed definition for each column,including its name, data type, length, purpose, and any applicable constraints.Data Constraints。
Specify any data constraints or validation rules that apply to the table, such as primary key constraints, foreign key relationships, or data type validation.Data Relationships。
Describe any relationships between this table and other tables in the database, such as foreign key relationships or joins.Data Integrity。
图表描述英语范文描述图表的英语写作是怎么写的，不妨看看别人的写作情况。
下面是店铺给大家整理例文的图表英语范文，供大家参阅!图表描述英语范文：Investment in Beijing不同国家和地区在京投资Investment in Beijing from different countries and regions From the pie chart given above, we can observe that it reflects the statistics of investmentin Beijing from different countries and regions. The proportion of investment from Hong Kongaccounts for 44%, ranking first. The percentage of investment from other 23 countries andregions ranks second among all, making up 20.8 %. Japan occupies 19.2%, ranking third. Whenit comes to the U.S.A., we can find that it takes up 16% , 28% lower than that of Hong Kong.The pie chart reveals the phenomenon that most of the investment in Beijing stem fromHong Kong. What exactly contribute to this phenomenon? Reasons can be listed as follows:in the first place, China's investment policy provide preferential treatment to investors fromHong Kong. They are more likely to be immune to high taxes and other charges. Moreover,quite a few Hong Kong investors hold the opinion that, with the same language, cultures,traditions and customs, mainland is an ideal and promising investment resort which will bebound to generate considerable profits. Last but not least, it will not take a long time tocommute between Hong Kong and Chinese mainland, the region advantage also has attractedmore Hong Kong investors to locate their companies and factories in the mainland.The public can benefit a lot from Hong Kong investment.People can buy products withsuperior quality at a comparatively cheaper price. However, balancing the investmentproportion from different countries is also a issue needed to be put at the top of relevantadministration departments’ agenda. Thus, people can be exposed to a greater variety ofproducts and have more purchasing options. (272 words)图表描述英语范文：坐下来餐厅发展趋势快餐和坐下来餐厅发展趋势The development tendency of fast food and sitdown restaurantFrom the curve chart given above, we can observe that the number meals of fast food andsitdown restaurant experienced some changes during the past several years. The number ofmeals of fast food increased slowly from 20 in 1970 to nearly 30 in 1980. From 1980 to 2000, itascended rapidly from 30 to approximately 90. On the contrary, when observing thestatistics of sitdown restaurant meals, we can find that it increased slowly from 20 in 1970 toroughly 50 in 2000.The curve chart informs us of the phenomenon that there exists some difference in thedevelopment tendency between fast food and sitdown restaurants. What exactly contributeto this phenomenon? Reasons can be listed as follows: for one thing, with the pace of modernlife quickening, people barely have much time to waste in lining up for restaurant meals, on thecontrary, fast food meals can do help busy people save a great deal of time. Additionally, theauthorities have issued some preferential policies to protect and encourage the rapidextension of fast food industry , thus the public can buy fast food at shops scattering aroundthe city. On the contrary , people in diminishing numbers are willing to eat at sitdownrestaurant. They think that eating atrestaurant is always time-consuming and inconvenient.Besides, food at restaurant is comparatively expensive than fast food.by observing the trend of the past, we may forecast that the number of fast food mealswill continue to rise in the years to come. However, we should also take the detrimental impactof fast food into consideration. Do remember that fast food is one of the main causing factorsof diseases such as heart attack, obesity and diabetes.图表描述英语范文：The changes of Chinese中国职业的变化The changes of Chinese professionsFrom the pie chart given above, we can observe that the professions structure of Chinesepeople experienced some changes during the past several years. From 1980 to 1999, thepercentage of agricultural professions decreased by 30% from 68% to 38%. During the sameperiod, however, service sectors increased rapidly from 5% to 22%. When it comes to themanufacturing professions, its percentage rose markedly from 27% in 1980 to 40% in 1999.The pie chart reveals the phenomenon that there exists some difference in thedevelopment tendency among different professions in China. What exactly contribute to thisphenomenon ? reasons can be listed as follows: for one thing, with the rapid process ofurbanization, people in mounting numbers, especially youngster, have left their village homes,moved into big cities and thus been out of agricultural industries. Moreover, quite a few people,especially college graduates hold that it is comparatively easy for them to make more money inthe service industry. When it comes to the manufacturing industry, its transformation mightbe attributed tothe adjustment of industrial structure: the authorities have issued somepreferential policies to promote the rapid extension of manufacturing industry, thus, moreworkforces are required.By observing the change over the past several years, we may forecast that theproportion of professions of service and manufacture will continue to rise. However, a highvalue should be placed on the development of agricultural industry by the public and theauthorities. Otherwise, with the number of people who are engaged in agriculture diminishing,we will one day have nothing to eat! (262words)图表描述英语范文：Different job inclination between boys and girls职业选择Different job inclination between boys and girlsFrom the bar chart given above, we can find that it reflects the statistics of professioninclination between girls and boys. Most obviously, 40% of boys intend to be a manager, withonly 15% of girls choosing this job. When it comes to the profession of teacher, we canobserve that 45% of girls prefer to take this job, while the proportion of boys only accountfor 5%, 40% lower than that of girls.The bar chart informs us of the phenomenon that there exists some difference inprofession inclination between boys and girls. What exactly contribute to this phenomenon? reasons can be listed as follow: for one thing, quite a few boys regard being a manager as asymbol of success. As this profession stands for promising futures, fat pay and competence.Moreover, boys’ decision to be a manager can also be attributed to the power of so-called“group dynamics”: whe n members of their social network prefer to be a manager aftergraduation, they are easilyinfluenced and imitate others’ behavior unconsciously orconsciously. When it comes to girls, the are more inclined to be a teacher. As this professionfeatures stability and respect. Take social and biological factors into account, we know that itis reasonable for girl to choose teacher as their ideal profession goals.Both girls and boys have rights to choose their profession. However, one thing we shouldbear in mind is that there exists no better or worse, superior or inferior jobs, but suitableand satisfactory ones. (254words).图表描述英语范文：大气污染空气污染范文Writing (图画提纲式议论文)1. Describe the picture2. Deduce the purpose of the drawer of the picture3. Suggest your counter – measures范文：The cartoon presents the Earth with a personified human face that seems quite unhappy.A examination of the picture immediately reveals that the source of its mood is the airpollution resulting from a huge number of automobiles spread around its surface.The cartoon, no doubt, aims at alarming humans of the heavy load we have exerted onEarth by our insatiable production and usage of automobiles. However, the majority of peoplemerely indulge in the celebration of the convenience brought by cars, while forgetting orsimply neglecting their harmful impact on the atmosphere. Admittedly, there are various factorscontributing to the current worldwide air pollution, but it is undeniable that the exhaustfrom automobiles is categorized asone of the major elements.I would like to make the following proposals to solve this problem: firstly, we should applythe most cutting-edge technologies in order to adopt new forms of energy as substitutes forfossil fuels. It should also be guaranteed that the clean energy be inexpensive so that it can bewidely accepted. Besides, there should be attempts to develop possible transportation means,so that citizens can be diverted from dependence on cars. In short, it is humans'responsibility to resume clean air for Earth.译文：这幅漫画以拟人的方式呈现地球，它的脸显得非常不高兴。
表格描述报告英文作文下载温馨提示:该文档是我店铺精心编制而成，希望大家下载以后，能够帮助大家解决实际的问题。
文档下载后可定制随意修改，请根据实际需要进行相应的调整和使用，谢谢!并且，本店铺为大家提供各种各样类型的实用资料，如教育随笔、日记赏析、句子摘抄、古诗大全、经典美文、话题作文、工作总结、词语解析、文案摘录、其他资料等等，如想了解不同资料格式和写法，敬请关注!Download tips: This document is carefully compiled by theeditor. I hope that after you download them,they can help yousolve practical problems. The document can be customized andmodified after downloading,please adjust and use it according toactual needs, thank you!In addition, our shop provides you with various types ofpractical materials,such as educational essays, diaryappreciation,sentence excerpts,ancient poems,classic articles,topic composition,work summary,word parsing,copyexcerpts,other materials and so on,want to know different data formats andwriting methods,please pay attention!The report shows the data clearly. It's easy to understand. There are many details included.The analysis in the report is quite in-depth. It helps us see the situation better.The findings of the report are interesting. They make us think.The conclusion drawn from the report is valuable. It can guide our decisions.。
图表描述类英语作文（4篇）图表描述类英语作文篇一The above bar chart informs us of the phenomenon that there exist some differences in additional working hours among diverse careers, especially between self-employed businessmen and civil servants. Self-employed businessmen spend nearly 2 hours per day in working overtime. On the contrary, civil servants’ additional working hours is the shortest, only less than 50 minutes per day. The overtime of scientific researchers, cultural and sports workers and teachers is 80 minutes, 70 minutes and 55 minutes respectively.Ample reasons can account for this phenomenon. Firstly, to make more profits, self-employed businessmen have to spend more time in manufacturing products, attracting customers, providing after-sale services and managing staff. Moreover, with the competition becoming fiercer, they have no alternative but to work overtime to avoid being eliminated by the market and their rivals. When it comes to civil servants, things have gone otherwise. Confronted with less risks as well as pressures and leading a steady and routine life, they don’t have to work overtime frequently.Working overtime is a two-bladed sword. Surely, it will generate considerable benefits. However, it will give rise to some damages, especially to our health. We should balance our work, life and health or we will eventually become a machine and salve of work.四级英语作文图表类篇二图片模板：It seems to me that the cartoon / drawing issending a message about ____________(图画内容)，which reveals ____________(稍作评价).In myperspective of view, ____________ (表明个人观点)。
在 PostgreSQL 中，可以使用 "\d tablename" 命令来查询表的描述信息。
这个命令将返回该表的所有列（字段）、每个列的数据类型、大小、默认值、约束条件等详细信息。
例如，运行 "\d employee" 将返回 "employee" 表的结构描述信息。
在结果中，可以查看到每列的名称、类型、是否可空以及默认值等信息。
对于表的约束，如主键等，也会在结果中显示。
此外，还可以使用 SQL 查询来获取表的描述信息。
例如，可以使用以下查询来获取表的列信息：
```sql
SELECT column_name, data_type, character_maximum_length, column_default, is_nullable
FROM information_schema.columns
WHERE table_name = 'your_table_name';
```
其中，将 "your_table_name" 替换为实际的表名。
这个查询将返回表的列信息，包括列名、数据类型、最大长度、默认值和是否可空等信息。
公司名录[dbo].[COMPANY]([CODE] [varchar](10)NOT NULL,[CMPDPT] [varchar](6)NULL,[TYPE] [smallint] NULL,[NAME] [varchar](50)NULL,[ADDR1] [varchar](50)NULL,[ADDR2] [varchar](50)NULL,[ADDR3] [varchar](50)NULL,[ZIP] [varchar](8)NULL,[PHONE] [varchar](20)NULL,[FAX] [varchar](20)NULL,[LEADTIME] [smallint] NULL,[PAYTERM] [smallint] NULL,[CONTACT] [varchar](30)NULL,[AREA] [varchar](20)NULL,[COUNTRY] [varchar](20)NULL,[TXNTYPE] [smallint] NOT NULL CONSTRAINT[DF_COMPANY_TXNTYPE] DEFAULT ((0)),[DISCOUNT] [real] NULL,[DISCTYPE] [smallint] NULL,[LASTTALK] [datetime] NULL,[SHORTNAME] [varchar](20)NOT NULL,[ACCT] [varchar](10)NULL,[ACCT1] [varchar](50)NULL,[ACCT2] [varchar](50)NULL,[ACCT3] [varchar](50)NULL,[PROFILE] [text] NULL,[FUNC] [text] NULL,[ACHV] [text] NULL,[CHAIRPERSON] [varchar](20)NULL,[CHIEFEDITOR] [varchar](20)NULL,[EMAILADDR] [varchar](50)NULL,[CMPPAYMENT] [varchar](6)NULL,[CMPCSDAYS] [smallint] NULL,[SEQ] [int] NULL,[ISEQ] [int] NOT NULL CONSTRAINT [DF_COMPANY_ISEQ] DEFAULT((0)), [JP] [varchar](50)NULL,[ISACTIVE] [smallint] NULL,[HighStore] [varchar](20)NULL,单号CREATE TABLE [dbo].[NUMBERS]([ID] [int] IDENTITY(1,1)NOT NULL,[PO] [smallint] NULL,[MPO] [varchar](6)NULL,[RCV] [smallint] NULL,[MRCV] [varchar](6)NULL,[SM] [smallint] NULL,[MSM] [varchar](6)NULL,[DN] [smallint] NULL,[MSH] [varchar](50)NULL,[SH] [bigint] NULL,[MDN] [varchar](6)NULL,[CRT] [bigint] NULL,[MCRT] [varchar](6)NULL,[IN_] [bigint] NULL,[MIN_] [varchar](6)NULL,[OUT] [bigint] NULL,[MOUT] [varchar](6)NULL,[TXF] [bigint] NULL,[MTXF] [varchar](6)NULL,[CNT] [bigint] NULL,[MCNT] [varchar](6)NULL,[BAT] [bigint] NULL,[MBAT] [varchar](6)NULL,[TXN] [bigint] NULL,[MTXN] [varchar](6)NULL,[IBAT] [bigint] NULL,[MIBAT] [varchar](6)NULL,[PAY] [bigint] NULL,[MPAY] [varchar](6)NULL,[ULDATE] [datetime] NULL,[NBSDATE] [datetime] NULL,[MDDATE] [datetime] NULL,[HLD] [bigint] NULL,[MHLD] [varchar](6)NULL,[NBSTKDATE] [datetime] NULL,[NBSTKTS] [bigint] NULL,[NBSTS] [bigint] NULL,[MSPLUTS] [bigint] NULL,[MPRT] [varchar](6)NULL,[PRT] [bigint] NULL,[DITMP] [bigint] NULL,[MDITMP] [varchar](6)NULL,[PKDN] [bigint] NULL,[MPKDN] [varchar](6)NULL,[CMONTHS] [bigint] NULL仓数CREATE TABLE [dbo].[TXNRACK]([RACK] [varchar](12)NOT NULL,[PLUCODE] [varchar](20)NOT NULL,[QTY] [int] NULL,[GRNBAT] [int] NOT NULL CONSTRAINT [DF_TXNRACK_GRNBAT] DEFAULT((0)), [ZTQTY] [int] NULL,CONSTRAINT [PK_TXNRACK] PRIMARY KEY CLUSTERED([RACK] ASC,[PLUCODE] ASC,[GRNBAT] ASCCREATE TABLE [dbo].[STKLEDGER]([PLUCODE] [varchar](20)NOT NULL,[TXNDATE] [datetime] NULL,[TXNTYPE] [smallint] NOT NULL,[NUMBER] [int] NOT NULL,[SEQ] [smallint] NULL CONSTRAINT [DF_STKLEDGER_SEQ] DEFAULT((0)), [QTY] [int] NULL,[LNKNUM] [int] NOT NULL,[PRICE] [money] NULL,[DISC] [real] NULL,[APV] [smallint] NOT NULL CONSTRAINT[DF_STKLEDGER_APV] DEFAULT((0)), [TORACK] [varchar](12)NOT NULL,[FROMRACK] [varchar](12)NOT NULL,[UNICODE] [varchar](20)NULL,[ODATE] [datetime] NULL,[GRNBAT] [int] NOT NULL CONSTRAINT[DF_STKLEDGER_GRNBAT] DEFAULT((0)), [SPLT] [smallint] NOT NULL CONSTRAINT [DF_STKLEDGER_SPLT] DEFAULT ((0)),[PAID] [datetime] NULL,[ORGPRICE] [money] NULL,[STATUS] [tinyint] NULL,[RCVQTY] [int] NULL,CONSTRAINT [PK_STKLEDGER] PRIMARY KEY CLUSTERED([PLUCODE] ASC,[TXNTYPE] ASC,[NUMBER] ASC,[LNKNUM] ASC,[TORACK] ASC,[FROMRACK] ASC,[GRNBAT] ASC,[SPLT] ASC类型[dbo].[PKSTYLE]([STYLE] [varchar](2)NOT NULL,[DESCRIPT] [varchar](10)NULL,[PIECES] [smallint] NULL,图书资料CREATE TABLE [dbo].[PLU]([ISBN] [varchar](20)NOT NULL,[TITLE] [varchar](160)NOT NULL,[AUTHOR] [varchar](80)NULL,[TRANSLATOR] [varchar](80)NULL,[SERIES] [varchar](160)NULL,[PRICE] [money] NOT NULL,[EDITION] [smallint] NULL,[NPRINT] [smallint] NULL,[CLSCODE] [varchar](10)NOT NULL,[CATEGORY] [varchar](6)NULL,[PUBLISHER] [varchar](10)NOT NULL,[PUBDATE] [datetime] NULL,[PAGES] [smallint] NULL,[WORDS] [int] NULL,[BINDING] [varchar](6)NULL,[CREDATE] [datetime] NOT NULL,[CREATBY] [varchar](6)NULL,[SIJIAOHAO] [varchar](20)NULL,[ISISBN] [smallint] NULL,[PLUCODE] [varchar](20)NOT NULL,[ISABOOK] [smallint] NOT NULL,[EXTCODE] [varchar](8)NULL,[BKSIZE] [varchar](6)NULL,[FULLCAT] [varchar](12)NULL,[PYSTYPE] [smallint] NOT NULL,[MODDATE] [datetime] NULL,[MODBY] [varchar](6)NULL,[JP] [varchar](160)NULL,[HIPRICE] [money] NULL,[AVPRICE] [money] NULL,[LSPRICE] [money] NULL,[LDATE] [datetime] NULL,[DPTCODE] [varchar](6)NULL,[PKSTYLE] [varchar](2)NULL,[PKPC] [smallint] NULL,[PKQTY] [smallint] NULL,[PKWT] [smallint] NULL,[WSDISC] [real] NULL,[RTNABLE] [smallint] NULL,[CMMUSE] [smallint] NULL,[APRICE] [money] NULL,[BPRICE] [money] NULL,[CPRICE] [money] NULL,[ISBN10] [varchar](20)NULL订单明细CREATE TABLE [dbo].[PODTL]([UNICODE] [varchar](20)NULL,[PLUCODE] [varchar](20)NOT NULL,[SEQ] [smallint] NOT NULL CONSTRAINT [DF_PODTL_SEQ] DEFAULT((0)), [NUMBER] [int] NOT NULL,[STATUS] [smallint] NULL,[DISC] [real] NULL,[PODATE] [datetime] NULL,[QTY] [int] NULL,[RCVQTY] [int] NULL,[APV] [smallint] NULL CONSTRAINT [DF_PODTL_APV] DEFAULT((0)),[RCVDATE] [datetime] NULL,[PRICE] [money] NULL,[TQTY] [int] NULL CONSTRAINT [DF_PODTL_TQTY] DEFAULT((0)),[PAIDQTY] [int] NULL CONSTRAINT [DF_PODTL_PAIDQTY] DEFAULT((0)), [PAIDAMT] [float] NULL CONSTRAINT [DF_PODTL_PAIDAMT] DEFAULT((0)), [TXFNUM] [varchar](20)NULL,装帧CREATE TABLE [dbo].[BINDING]([CODE] [int] NOT NULL,[BINDING] [varchar](50)NULL,[STATUS] [int] NOT NULL CONSTRAINT [DF_BINDING_STATUS] DEFAULT((0)), 订单单头CREATE TABLE [dbo].[POHDR]([VENDOR] [varchar](10)NULL,[PHONE] [varchar](20)NULL,[FAX] [varchar](20)NULL,[CONTACT] [varchar](30)NULL,[CREDATE] [datetime] NULL,[CREATEDBY] [varchar](10)NULL,[NUMBER] [int] NOT NULL,[DLVYDATE] [datetime] NULL,[REMARKS] [varchar](100)NULL,[SENDDATE] [datetime] NULL,[STATUS] [smallint] NULL,[APVBY] [varchar](10)NULL,[REASON] [smallint] NULL,[DISCOUNT] [real] NULL,[PAIDAMT] [money] NULL,[PAID] [datetime] NULL,[RECEIPT] [varchar](20)NULL,[DLVYNUM] [int] NULL,[ISTBPO] [tinyint] NULL CONSTRAINT [DF_POHDR_ISTBPO] DEFAULT((0)), [ISCSM] [tinyint] NULL CONSTRAINT [DF_POHDR_ISCSM] DEFAULT((0)), [DPTCODE] [varchar](6)NULL,CREATE TABLE [dbo].[BOOKS]([UNICODE] [varchar](20)NOT NULL,[BCODE] [varchar](20)NOT NULL,[BTYPE] [int] NOT NULL CONSTRAINT [DF_BOOKS_BTYPE] DEFAULT((0)), [LUNICODE] [varchar](20)NULL,[TITLE] [varchar](200)NULL,[ASSESSMENT] [money] NOT NULL CONSTRAINT[DF_BOOKS_ASSESSMENT] DEFAULT ((0)),[PRICE] [money] NOT NULL CONSTRAINT [DF_BOOKS_PRICE] DEFAULT((0)), [GRADE] [int] NULL,[SUBJECTS] [int] NULL,[PUBLISHER] [varchar](10)NULL,[PUBDATE] [datetime] NULL,[CREATBY] [varchar](8)NULL,[CREDATE] [datetime] NULL,[TEXTTYPE] [int] NOT NULL CONSTRAINT[DF_BOOKS_TEXTTYPE] DEFAULT((0)), [SEM] [varchar](10)NULL,[SDISC] [int] NOT NULL CONSTRAINT [DF_BOOKS_SDISC] DEFAULT((100)), [STATUS] [int] NOT NULL CONSTRAINT [DF_BOOKS_STATUS] DEFAULT((0)), 商品类型CREATE TABLE [dbo].[BTYPE]([CODE] [int] NOT NULL,[BTYPE] [varchar](50)NULL,[STATUS] [int] NOT NULL CONSTRAINT [DF_BTYPE_STATUS] DEFAULT((0)), 开本CREATE TABLE [dbo].[FORMAT]([CODE] [int] NOT NULL,[FORMAT] [varchar](50)NULL,[STATUS] [int] NOT NULL CONSTRAINT [DF_FORMAT_STATUS] DEFAULT((0)), 年级CREATE TABLE [dbo].[GRADE]([CODE] [int] NOT NULL,[GRADE] [varchar](50)NULL,[STATUS] [int] NOT NULL CONSTRAINT [DF_GRADE_STATUS] DEFAULT((0)),教材类型CREATE TABLE [dbo].[TEXTTYPE]([CODE] [int] NOT NULL,[TEXTTYPE] [varchar](50)NULL,[STATUS] [int] NOT NULL CONSTRAINT[DF_TEXTTYPE_STATUS] DEFAULT((0)), 退货单CREATE TABLE [dbo].[PRET]([NUMBER] [int] NOT NULL,[CREDATE] [datetime] NULL,[CREATEBY] [varchar](10)NULL,[RETDATE] [datetime] NULL,[REMARK] [varchar](200)NULL,[HANDLEBY] [varchar](20)NULL,[VENDOR] [varchar](10)NULL,[APVBY] [varchar](10)NULL,[REASON] [smallint] NULL,[PAID] [datetime] NULL,[WAREHOUSE] [varchar](8)NULL,[VALBY] [varchar](6)NULL,[PKBY] [varchar](6)NULL,[DLVBY] [varchar](6)NULL,[TXFBY] [varchar](6)NULL,[TXFDATE] [datetime] NULL,[DLVYDATE] [datetime] NULL,[TRAMT] [float] NULL,[TRNET] [float] NULL,[TRCNT] [int] NULL,[TRQTY] [int] NULL,[LTERM] [varchar](6)NULL,[LMEANS] [varchar](2)NULL,[LDSTRB] [varchar](10)NULL,[L2DSTRB] [varchar](10)NULL,[FIX] [smallint] NULL,[SEL] [smallint] NULL,[PWS] [real] NULL,[PKS] [smallint] NULL,[DNUM] [int] NULL,[CHK] [smallint] NULL,[ADDR] [varchar](100)NULL,[ZIP] [varchar](10)NULL,[PHONE] [varchar](20)NULL,[CONTACT] [varchar](30)NULL,[STKMOVENUM] [int] NULL,架号CREATE TABLE [dbo].[RACK]([WAREHOUSE] [varchar](8)NULL,[RACK] [varchar](12)NOT NULL,[STKCNT] [smallint] NOT NULL,[COUNTED] [smallint] NOT NULL,[LVL] [varchar](8)NULL,[CNTDATE] [datetime] NULL,批销单CREATE TABLE [dbo].[SALEHDR]([CUSTOMER] [varchar](10)NULL,[CREDATE] [datetime] NULL,[CREATEBY] [varchar](10)NULL,[NUMBER] [int] NOT NULL,[TXNTYPE] [smallint] NULL,[APVBY] [varchar](10)NULL,[WAREHOUSE] [varchar](8)NULL,[PAYMENT] [varchar](6)NULL,[TAX] [real] NULL,[PAID] [datetime] NULL,[TXNTIME] [char](4)NULL,[ISTBPO] [tinyint] NULL CONSTRAINT[DF_SALEHDR_ISTBPO] DEFAULT((0)), [PDAYS] [smallint] NULL,[CSDAYS] [smallint] NULL,[URGENT] [smallint] NULL,[INUM] [int] NULL,[REMARKS] [varchar](40)NULL,[SMNUM] [int] NULL,[DSEQ] [varchar](20)NULL,[VALBY] [varchar](6)NULL,[PKBY] [varchar](6)NULL,[DLVBY] [varchar](6)NULL,[RCVNUM] [int] NULL,[PCKPSN] [varchar](6)NULL,[vendor] [varchar](20)NULL,[isload] [smallint] NULL,[apv] [smallint] NULL,期号CREATE TABLE [dbo].[SEM]([SEM] [varchar](10)NULL,[CODE] [varchar](10)NOT NULL,[DESCRIPT] [varchar](20)NULL,[CURSEM] [smallint] NULL,[YR] [smallint] NULL,客退单CREATE TABLE [dbo].[SRET]([NUMBER] [int] NOT NULL,[CREDATE] [datetime] NULL,[CREATEBY] [varchar](10)NULL,[RETDATE] [datetime] NULL,[REMARK] [varchar](100)NULL,[HANDLEBY] [varchar](20)NULL,[CUSTOMER] [varchar](10)NULL,[APVBY] [varchar](10)NULL,[REASON] [smallint] NULL,[PAID] [datetime] NULL,[ISADJ] [tinyint] NULL CONSTRAINT [DF_SRET_ISADJ] DEFAULT((0)),[DPTCODE] [varchar](8)NULL,[CUSNUM] [int] NULL,[VALBY] [varchar](6)NULL,[UPKBY] [varchar](6)NULL,[TXFBY] [varchar](6)NULL,[TXFDATE] [datetime] NULL,[DLVBY] [varchar](6)NULL,[DLVYDATE] [datetime] NULL,[TRCNT] [int] NULL,[TRAMT] [float] NULL,[TRNET] [float] NULL,[TRQTY] [int] NULL,[LTERM] [varchar](6)NULL,[LMEANS] [varchar](2)NULL,[LDSTRB] [varchar](10)NULL,[L2DSTRB] [varchar](10)NULL,[FIX] [smallint] NULL,[SEL] [smallint] NULL,[PWS] [real] NULL,[PKS] [smallint] NULL,[DNUM] [int] NULL,点仓单CREATE TABLE [dbo].[STKCNT]([NUMBER] [int] NOT NULL,[TXNDATE] [datetime] NULL,[CREDATE] [datetime] NULL,[CREATEBY] [varchar](10)NULL,[REMARKS] [varchar](100)NULL,[WAREHOUSE] [varchar](8)NULL,[CFM] [smallint] NULL CONSTRAINT [DF_STKCNT_CFM] DEFAULT((0)),点仓单明细CREATE TABLE [dbo].[STKCNTDTL]([RACK] [varchar](12)NOT NULL,[PLUCODE] [varchar](20)NOT NULL,[TXNDATE] [datetime] NULL,[NUMBER] [int] NOT NULL,[QTY] [int] NULL,[CFM] [smallint] NULL CONSTRAINT [DF_STKCNTDTL_CFM] DEFAULT((0)), [SEQ] [smallint] NOT NULL,[PRICE] [money] NULL,[HIPRICE] [money] NULL,[AVPRICE] [money] NULL,[LSPRICE] [money] NULL,电子礼卷标准CREATE TABLE [dbo].[CARD_ELEC_MONEY]([ELEC] [money] NOT NULL CONSTRAINT [DF_CARD_ELEC_MONEY_ELEC] DEFAULT ((0)),[HMONEY] [money] NOT NULL CONSTRAINT [DF_CARD_ELEC_MONEY_HMONEY] DEFAULT((0)),[BDATE] [datetime] NOT NULL,[EDATE] [datetime] NOT NULL,[CREATBY] [varchar](10)NULL,[STATUS] [int] NOT NULL CONSTRAINT[DF_CARD_ELEC_MONEY_STATUS] DEFAULT ((0)),卡数据CREATE TABLE [dbo].[CARDINFO]([CARDNUM] [varchar](20)NOT NULL,[CARDTYPE] [int] NOT NULL,[ID] [varchar](20)NULL,[CNAME] [varchar](20)NULL,[SEX] [int] NOT NULL,[BIRTHDAY] [datetime] NULL,[EDU] [int] NULL,[INTYPE] [int] NOT NULL CONSTRAINT[DF_CARDINFO_INTYPE] DEFAULT((0)), [PHONE] [varchar](50)NULL,[MOBILE] [varchar](50)NULL,[FAX] [varchar](50)NULL,[ADDR] [varchar](200)NULL,[QQ] [varchar](20)NULL,[MSN] [varchar](50)NULL,[EMAIL] [varchar](50)NULL,[CREDATE] [datetime] NULL,[CREATBY] [varchar](20)NULL,[STORE] [varchar](10)NULL,[VLDDATE] [datetime] NULL,[POINTS] [money] NULL,[ELEC] [money] NULL,[CREDIT] [money] NULL,[FIRSTUSE] [datetime] NULL,[USECNT] [int] NOT NULL CONSTRAINT[DF_CARDINFO_USECNT] DEFAULT((0)), [LASTUSE] [datetime] NULL,[FIRSTUSERSTORE] [varchar](10)NULL,[LASTUSESTORE] [varchar](10)NULL,[STATUS] [int] NOT NULL CONSTRAINT[DF_CARDINFO_STATUS] DEFAULT((0)), [MEMO] [ntext] NULL,到货验收单CREATE TABLE [dbo].[GIN]([NUMBER] [int] NOT NULL,[CREDATE] [datetime] NULL,[CREATEBY] [varchar](10)NULL,[RCVDATE] [datetime] NULL,[REMARK] [varchar](100)NULL,[RECEIVEBY] [varchar](20)NULL,[VENDOR] [varchar](10)NULL,[STATUS] [tinyint] NULL CONSTRAINT [DF_GIN_STATUS] DEFAULT((0)), [DNUM] [varchar](12)NULL,[TNUM] [varchar](20)NULL,[PQTY] [int] NULL,[DPTCODE] [varchar](6)NULL,[OPT] [tinyint] NULL CONSTRAINT [DF_GIN_OPT] DEFAULT((0)),[APVBY] [varchar](6)NULL,[VALBY] [varchar](6)NULL,[UPKBY] [varchar](6)NULL,[RCVNUM] [int] NULL,[TXFBY] [varchar](6)NULL,[TXFDATE] [datetime] NULL,[DLVYDATE] [datetime] NULL,[TRCNT] [int] NULL,[TRQTY] [int] NULL,[TRAMT] [float] NULL,[TRNET] [float] NULL,[LTERM] [varchar](6)NULL,[LMEANS] [varchar](2)NULL,[LDSTRB] [varchar](10)NULL,[L2DSTRB] [varchar](10)NULL,[FIX] [smallint] NULL,[SEL] [smallint] NULL,[PWS] [real] NULL,[PKS] [smallint] NULL,[RDNUM] [int] NULL,[DLVBY] [varchar](6)NULL,[REASON] [smallint] NULL,卡销费CREATE TABLE [dbo].[CARDTRANS]([CARDNUM] [varchar](20)NOT NULL,[STORE] [varchar](10)NOT NULL,[TERMINAL] [varchar](10)NOT NULL,[TXNDATE] [datetime] NOT NULL,[AMOUNT] [money] NOT NULL CONSTRAINT [DF_CARDTRANS_AMOUNT] DEFAULT ((0)),[TXNTYPE] [int] NOT NULL CONSTRAINT [DF_CARDTRANS_TXNTYPE] DEFAULT ((0)),[STATUS] [int] NOT NULL CONSTRAINT[DF_CARDTRANS_STATUS] DEFAULT((0)), CONSTRAINT [PK_CARDTRANS] PRIMARY KEY CLUSTERED([CARDNUM] ASC,[TERMINAL] ASC,[STORE] ASC,[TXNDATE] ASC,[TXNTYPE] ASC到货验收明细CREATE TABLE [dbo].[GINDTL]([PLUCODE] [varchar](20)NOT NULL,[TXNDATE] [datetime] NULL,[STATUS] [tinyint] NULL CONSTRAINT [DF_GINDTL_STATUS] DEFAULT((0)), [NUMBER] [int] NOT NULL,[SEQ] [smallint] NOT NULL CONSTRAINT [DF_GINDTL_SEQ] DEFAULT((0)), [OQTY] [int] NULL,[QTY] [int] NULL,[RQTY] [int] NULL,[CQTY] [int] NULL CONSTRAINT [DF_GINDTL_CQTY] DEFAULT((0)),[PONUM] [int] NULL,[CPONUM] [int] NULL,[TXFNUM] [varchar](20)NULL,[PRICE] [money] NULL,[RPRICE] [money] NULL,[DISC] [real] NULL,[RDISC] [real] NULL,[OPT] [tinyint] NULL CONSTRAINT [DF_GINDTL_OPT] DEFAULT((0)),[APV] [tinyint] NULL CONSTRAINT [DF_GINDTL_APV] DEFAULT((0)),[PKSTYLE] [varchar](2)NULL,[PKPC] [smallint] NULL,[PKQTY] [smallint] NULL,[PKWT] [real] NULL CONSTRAINT [DF_GINDTL_PKWT] DEFAULT((1)),[UNICODE] [varchar](20)NULL,[PUBDATE] [datetime] NULL,[RTLPRICE] [money] NULL CONSTRAINT[DF_GINDTL_RTLPRICE] DEFAULT((0)),[APRICE] [money] NULL CONSTRAINT [DF_GINDTL_APRICE] DEFAULT((0)), [BPRICE] [money] NULL CONSTRAINT [DF_GINDTL_BPRICE] DEFAULT((0)), [CPRICE] [money] NULL CONSTRAINT [DF_GINDTL_CPRICE] DEFAULT((0)), [WSDISC] [real] NULL CONSTRAINT [DF_GINDTL_WSDISC] DEFAULT((100)), 商品资料CREATE TABLE [dbo].[BK]([BCODE] [varchar](20)NOT NULL,[ISBN] [varchar](20)NULL,[BTYPE] [int] NOT NULL CONSTRAINT [DF_BK_BTYPE] DEFAULT((0)),[TITLE] [varchar](200)NULL,[AUTHOR] [varchar](100)NULL,[TRANSLATOR] [varchar](100)NULL,[EDITION] [int] NULL,[CLSCODE] [varchar](12)NULL,[MCLSCODE] [varchar](12)NULL,[PAGES] [int] NULL,[WORDS] [money] NULL,[BINDING] [int] NULL,[FORMAT] [int] NULL,[CREDATE] [datetime] NULL CONSTRAINT [DF_BK_CREDATE] DEFAULT (getdate()),[CREATBY] [varchar](8)NULL,[EXTCODE] [varchar](10)NULL,[SERIES] [varchar](200)NULL,[PRICE] [money] NULL,[ISBOUND] [int] NOT NULL CONSTRAINT [DF_BK_ISBOUND] DEFAULT((0)), [BOUNDCODE] [varchar](20)NULL,[PUBDATE] [datetime] NULL,[PUBLISHER] [varchar](10)NULL,[MEMO] [ntext] NULL,[STATUS] [int] NOT NULL CONSTRAINT [DF_BK_STATUS] DEFAULT((0)), [MODDATE] [datetime] NULL CONSTRAINT [DF_BK_MODDATE] DEFAULT (getdate()),[MODBY] [varchar](8)NULL,[INTRO] [ntext] NULL,[PIC] [image] NULL,[WEIGHT] [money] NULL,[PRTCNT] [int] NULL,[CIP] [varchar](20)NULL,教材控制数CREATE TABLE [dbo].[TEXTCTLMONEY]([STORE] [varchar](10)NOT NULL,[CTLMONEY] [money] NOT NULL CONSTRAINT [DF_TEXTCTLMONEY_CTLMONEY] DEFAULT((0)),[BDATE] [datetime] NOT NULL,[EDATE] [datetime] NOT NULL,[STATUS] [int] NOT NULL CONSTRAINT [DF_TEXTCTLMONEY_STATUS] DEFAULT ((0)),CONSTRAINT [PK_TEXTCTLMONEY] PRIMARY KEY CLUSTERED([STORE] ASC,[BDATE] ASC,[EDATE] ASC收货单CREATE TABLE [dbo].[GRN]([NUMBER] [int] NOT NULL,[CREDATE] [datetime] NULL,[CREATEBY] [varchar](10)NULL,[RCVDATE] [datetime] NULL,[REMARK] [varchar](100)NULL,[PONUM] [int] NULL,[RECEIVEBY] [varchar](20)NULL,[INVOICE] [varchar](20)NULL,[VENDOR] [varchar](10)NULL,[APVBY] [varchar](10)NULL,[REASON] [smallint] NULL,[ISTBPO] [tinyint] NULL CONSTRAINT [DF_GRN_ISTBPO] DEFAULT((0)), [ISCSM] [tinyint] NULL CONSTRAINT [DF_GRN_ISCSM] DEFAULT((0)),[DNUM] [varchar](12)NULL,[TNUM] [varchar](20)NULL,[PQTY] [int] NULL,[DPTCODE] [varchar](6)NULL,[VALBY] [varchar](6)NULL,[UPKBY] [varchar](6)NULL,[GINNUM] [int] NULL,[SMNUM] [int] NULL,[CHK] [smallint] NULL CONSTRAINT [DF_GRN_CHK] DEFAULT((0)),仓号CREATE TABLE [dbo].[WAREHOUSE]([CODE] [varchar](8)NOT NULL,[DESCRIPT] [varchar](20)NULL,[TYPE] [smallint] NULL,[TXF] [smallint] NULL,[STORE] [varchar](8)NULL,CONSTRAINT [PK_WAREHOUSE] PRIMARY KEY CLUSTERED([CODE] ASC各店书目资料CREATE TABLE [dbo].[BOOKS_STORE]([UNICODE] [varchar](20)NOT NULL,[BCODE] [varchar](20)NOT NULL,[BTYPE] [int] NOT NULL CONSTRAINT[DF_BOOKS_STORE_BTYPE] DEFAULT((0)), [LUNICODE] [varchar](20)NULL,[TITLE] [varchar](200)NULL,[ASSESSMENT] [money] NOT NULL CONSTRAINT [DF_BOOKS_STORE_ASSESSMENT] DEFAULT((0)),[PRICE] [money] NOT NULL CONSTRAINT [DF_BOOKS_STORE_PRICE] DEFAULT ((0)),[GRADE] [int] NULL,[SUBJECTS] [int] NULL,[PUBLISHER] [varchar](10)NULL,[PUBDATE] [datetime] NULL,[CREATBY] [varchar](8)NULL,[CREDATE] [datetime] NULL,[TEXTTYPE] [int] NOT NULL CONSTRAINT[DF_BOOKS_STORE_TEXTTYPE] DEFAULT ((0)),[SEM] [varchar](10)NULL,[SDISC] [int] NOT NULL CONSTRAINT [DF_BOOKS_STORE_SDISC] DEFAULT ((100)),[STATUS] [int] NOT NULL CONSTRAINT [DF_BOOKS_STORE_STATUS] DEFAULT ((0)),[STORE] [varchar](10)NOT NULL,进度表CREATE TABLE [dbo].[STKLEDGER1]([PLUCODE] [varchar](20)NOT NULL,[TXNDATE] [datetime] NULL,[TXNTYPE] [smallint] NOT NULL,[NUMBER] [int] NOT NULL,[SEQ] [smallint] NULL CONSTRAINT [DF_STKLEDGER_SEQ1] DEFAULT((0)), [QTY] [int] NULL,[LNKNUM] [int] NOT NULL,[PRICE] [money] NULL,[DISC] [real] NULL,[APV] [smallint] NOT NULL CONSTRAINT[DF_STKLEDGER_APV1] DEFAULT((0)), [TORACK] [varchar](12)NOT NULL,[FROMRACK] [varchar](12)NOT NULL,[UNICODE] [varchar](20)NULL,[ODATE] [datetime] NULL,[GRNBAT] [int] NOT NULL CONSTRAINT [DF_STKLEDGER_GRNBAT1] DEFAULT ((0)),[SPLT] [smallint] NOT NULL CONSTRAINT [DF_STKLEDGER_SPLT1] DEFAULT ((0)),[PAID] [datetime] NULL,[ORGPRICE] [money] NULL,CONSTRAINT [PK_STKLEDGER1] PRIMARY KEY CLUSTERED([PLUCODE] ASC,[TXNTYPE] ASC,[NUMBER] ASC,[LNKNUM] ASC,[TORACK] ASC,[FROMRACK] ASC,[GRNBAT] ASC,[SPLT] ASCCREATE TABLE [dbo].[DNOTE]([CUSTOMER] [varchar](10)NOT NULL,[PLUCODE] [varchar](20)NOT NULL,[UNICODE] [varchar](20)NOT NULL,[SEQ] [datetime] NOT NULL,[SMNUM] [int] NOT NULL,[TXFNUM] [int] NULL CONSTRAINT [DF_DNOTE_NEW_TXFNUM] DEFAULT((0)), [QTY] [int] NULL CONSTRAINT [DF_DNOTE_NEW_QTY] DEFAULT((0)),[RQTY] [int] NULL CONSTRAINT [DF_DNOTE_NEW_RQTY] DEFAULT((0)),[RLSDATE] [datetime] NULL,[CFMDATE] [datetime] NULL,[DPTCODE] [varchar](6)NULL,[USERCODE] [varchar](6)NULL,[WAREHOUSE] [varchar](8)NULL,[RACK] [varchar](12)NULL,[DLVYDATE] [datetime] NULL,[LCOST] [int] NULL CONSTRAINT [DF_DNOTE_NEW_GENSM] DEFAULT((0)), [STATUS] [smallint] NOT NULL CONSTRAINT[DF_DNOTE_NEW_STATUS] DEFAULT ((0)),[BATNUM] [int] NULL,[PKCNT] [smallint] NULL CONSTRAINT[DF_DNOTE_NEW_PKCNT] DEFAULT((0)), [DNUM] [int] NULL,[COST] [money] NULL CONSTRAINT [DF_DNOTE_NEW_COST] DEFAULT((0)), [PKNUM] [int] NOT NULL CONSTRAINT [DF_DNOTE_NEW_PKNUM] DEFAULT((0)), [PKSEQ] [int] NULL,[VIA] [varchar](2)NULL,[REF] [varchar](20)NULL CONSTRAINT [DF_DNOTE_NEW_REASON] DEFAULT ((0)),[URGENT] [smallint] NULL CONSTRAINT [DF_DNOTE_NEW_URGENT] DEFAULT ((0)),[SENDBY] [varchar](10)NULL,[FORWARDER] [varchar](10)NULL,[FWD2ND] [varchar](10)NULL,[SEM] [varchar](10)NULL,[PKNG] [int] NULL,[SFROM] [varchar](6)NULL,[DISC] [float] NULL CONSTRAINT [DF_DNOTE_NEW_DISC] DEFAULT((100)), [PDAYS] [smallint] NULL CONSTRAINT[DF_DNOTE_NEW_PDAYS] DEFAULT((0)), [PAIDDATE] [datetime] NULL,[PAYMENT] [varchar](6)NULL,[IBAT] [int] NULL,[INVOICE] [int] NULL,[CLSDATE] [datetime] NULL,[ACCT] [varchar](10)NULL,[PLDATE] [datetime] NULL,[PRICE] [money] NULL CONSTRAINT [DF_DNOTE_NEW_PRICE] DEFAULT((0)), [CSDAYS] [smallint] NULL CONSTRAINT [DF_DNOTE_NEW_CSDAYS] DEFAULT ((0)),[FLEET] [varchar](10)NULL,[PLATE] [varchar](10)NULL,[VCODE] [varchar](6)NULL,[ACODE] [varchar](6)NULL,[IPONUM] [int] NULL,[CQTY] [int] NULL CONSTRAINT [DF_DNOTE_NEW_CQTY] DEFAULT((0)),[CSEQ] [varchar](20)NULL,[DSEQ] [varchar](20)NULL,[PSEQ] [int] NULL,[REMARKS] [varchar](40)NULL,[MDATE] [datetime] NULL,[LDATE] [datetime] NULL,[DCOST] [money] NULL CONSTRAINT [DF_DNOTE_NEW_DCOST] DEFAULT((0)), [PKGRP] [varchar](6)NULL,[PKPSN] [varchar](6)NULL,[CHQNUM] [varchar](20)NULL,[RDNUM] [varchar](20)NULL,[GRNBAT] [int] NOT NULL CONSTRAINT[DF_DNOTE_NEW_GRNBAT] DEFAULT((0)), [PAID] [datetime] NULL,[APPAID] [datetime] NULL,[PLUPRICE] [money] NULL,[PLURACK] [varchar](12)NULL,[PCKPSN] [varchar](20)NULL,[VENDOR] [varbinary](20)NULL,[TYPE] [smallint] NULL,付款单CREATE TABLE [dbo].[AP]([DPTCODE] [varchar](6)NULL,[NUMBER] [int] NOT NULL,[VENDOR] [varchar](10)NULL,[HANDLEBY] [varchar](20)NULL,[SDATE] [datetime] NULL,[ALTFEE] [money] NULL,[DSTFEE] [money] NULL,[OTHFEE] [money] NULL,[CREDATE] [datetime] NULL,[CREATEBY] [varchar](6)NULL,[REMARKS] [varchar](100)NULL,[APVBY] [varchar](6)NULL,[PDATE] [datetime] NULL,[VENTAX] [varchar](50)NULL,[PAIDNUM] [varchar](50)NULL付款单明细CREATE TABLE [dbo].[APSETTLEMENT]( [NUMBER] [int] NOT NULL,[TXFNUM] [varchar](20)NULL,[DPTCODE] [varchar](6)NULL,[APNUM] [int] NOT NULL,[PLUCODE] [varchar](20)NOT NULL, [QTY] [int] NULL,[RQTY] [int] NULL,[AMOUNT] [float] NULL,[SETTLEDATE] [datetime] NULL,[REMARKS] [varchar](20)NULL,[SETTLED] [smallint] NULL,[APV] [smallint] NOT NULL,[TXNTYPE] [smallint] NOT NULL,[RCVDATE] [datetime] NULL,[RCVNUM] [int] NULL,[SEQ] [int] NULL付款单临时表CREATE TABLE [dbo].[APTMP]([CODE] [varchar](10)NOT NULL,[VNAME] [varchar](50)NULL,[NUMBER] [int] NOT NULL,[TYPE] [varchar](10)NOT NULL,[TXNDATE] [datetime] NULL,[QTY] [int] NULL,[AMT] [float] NULL,[NET] [float] NULL,[USERCODE] [varchar](6)NOT NULL, [SEL] [smallint] NULL,[TNUM] [varchar](50)NULL付款单明细数据临时表CREATE TABLE [dbo].[APTMPDTL]([VENDOR] [varchar](10)NOT NULL,[NUMBER] [int] NOT NULL,[PLUCODE] [varchar](20)NOT NULL,[RDATE] [datetime] NULL,[PRICE] [money] NULL,[COST] [money] NULL,[PAIDAMT] [money] NULL,[RQTY] [int] NULL,[RDISC] [real] NULL,[USERCODE] [varchar](6)NOT NULL,[GRNBAT] [int] NOT NULL,[TXNTYPE] [smallint] NOT NULL调剂单CREATE TABLE [dbo].[STKMOVE]([NUMBER] [int] NOT NULL,[TXNTYPE] [smallint] NOT NULL,[TXNDATE] [datetime] NULL,[CREDATE] [datetime] NULL,[CREATEBY] [varchar](10)NULL,[REMARKS] [varchar](200)NULL,[REASON] [smallint] NULL,[APVBY] [varchar](10)NULL,[VALBY] [varchar](6)NULL,[STKSRC] [varchar](20)NULL,[STATUS] [tinyint] NULL,[RCVQTY] [int] NULL,[TXFACK] [bit] NOT NULL,[URGENT] [bit] NULL,[LGNUM] [bigint] NOT NULL,CONSTRAINT [PK_STKMOVE] PRIMARY KEY CLUSTERED([NUMBER] ASC,[TXNTYPE] ASC,[LGNUM] ASC征订书目CREATE TABLE [dbo].[TEXTBOOK]([NUMBER] [varchar](8)NOT NULL,[SEM] [varchar](10)NOT NULL,[UNICODE] [varchar](18)NOT NULL,[TITLE] [varchar](80)NULL,[PRICE] [real] NULL,[GRADE] [varchar](6)NULL,[SUBJECT] [varchar](10)NULL,[PUBLISHER] [varchar](10)NULL,[PUBDATE] [datetime] NULL,[VER] [tinyint] NULL,[VENDOR] [varchar](10)NULL,[PRINTBY] [varchar](10)NULL,[CATEGORY] [varchar](6)NULL,[BSTOCK] [int] NULL CONSTRAINT [DF_TEXTBOOK_PREMARKED_9__11] DEFAULT ((0)),[STOCK] [int] NULL CONSTRAINT[DF_TEXTBOOK_STOCK_2__11] DEFAULT((0)), [PURCHASED] [int] NULL CONSTRAINT [DF_TEXTBOOK_PURCHASED] DEFAULT ((0)),[RECEIVED] [int] NULL CONSTRAINT[DF_TEXTBOOK_RECEIVED_4__11] DEFAULT ((0)),[ADJUSTED] [int] NULL CONSTRAINT[DF_TEXTBOOK_ADJUSTED_1__11] DEFAULT ((0)),[ORDERED] [int] NULL CONSTRAINT [DF_TEXTBOOK_ORDERED_3__11] DEFAULT ((0)),[REQUIRED] [int] NULL CONSTRAINT[DF_TEXTBOOK_REQUIRED_6__11] DEFAULT ((0)),[ASSIGNED] [int] NULL CONSTRAINT[DF_TEXTBOOK_ASSIGNED_6__11] DEFAULT ((0)),[DELIVERED] [int] NULL CONSTRAINT [DF_TEXTBOOK_DELIVERED_5__11] DEFAULT((0)),[PLUCODE] [varchar](20)NULL,[USETERMS] [smallint] NULL CONSTRAINT [DF_TEXTBOOK_USAGE_9__11] DEFAULT((0)),[VIA] [smallint] NULL CONSTRAINT [DF_TEXTBOOK_VIA_7__11] DEFAULT ((0)),[RDISC] [real] NULL CONSTRAINT [DF_TEXTBOOK_SDISC_8__11] DEFAULT ((100)),[SDISC] [real] NULL CONSTRAINT [DF_TEXTBOOK_SDISC] DEFAULT((100)), [PKSTYLE] [varchar](10)NULL CONSTRAINT[DF_TEXTBOOK_PKSTYLE] DEFAULT ('K'),[PKQTY] [smallint] NULL CONSTRAINT[DF_TEXTBOOK_PKQTY] DEFAULT((1)), [CREATEBY] [varchar](10)NULL,[AVL] [bit] NULL CONSTRAINT [DF_TEXTBOOK_avl] DEFAULT((0)),[SEASON] [varchar](10)NULL,[OUNICODE] [varchar](20)NULL,用户代码CREATE TABLE [dbo].[EMPLOYEES]([CODE] [varchar](6)NOT NULL,[DESCRIPT] [varchar](20)NULL,[WKGROUP] [varchar](6)NULL,[OPID] [varchar](20)NULL,[PASSOFUSER] [varchar](20)NULL,[TYPE] [smallint] NULL CONSTRAINT [DF_EMPLOYEES_TYPE] DEFAULT((0)), [WAREHOUSE] [varchar](10)NULL,科目CREATE TABLE [dbo].[SUBJECTS]([CODE] [int] NOT NULL,[SUBJECTS] [varchar](50)NULL,[STATUS] [int] NOT NULL CONSTRAINT[DF_SUBJECTS_STATUS] DEFAULT((0)), CREATE TABLE [dbo].[Dispense]([number] [bigint] NOT NULL,[plucode] [varchar](20)NOT NULL,[store] [varchar](20)NOT NULL,[sonStore] [varchar](20)NOT NULL,[qty] [int] NOT NULL,[apv] [smallint] NULL,[credate] [datetime] NULL,[crebody] [varchar](20)NULL,CONSTRAINT [PK_Dispense] PRIMARY KEY CLUSTERED([number] ASC,[plucode] ASC,。
