Новые проводки (постановка)
Материал из GedeminWiki
(Различия между версиями)
SYSDBA (обсуждение | вклад) (Новая страница: « <syntaxhighlight lang="sql"> CREATE TABLE a2_entry ( id dintkey, companykey dintkey, entrydate dtimestamp_notnull, dt dforeig…») |
SYSDBA (обсуждение | вклад) |
||
| Строка 2: | Строка 2: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
CREATE TABLE a2_entry ( | CREATE TABLE a2_entry ( | ||
| − | id | + | id dintkey, |
| − | companykey dintkey, | + | masterentrykey dforeignkey, |
| − | entrydate | + | companykey dintkey, |
| − | dt | + | entrydate dtimestamp_notnull, |
| − | ct | + | dt dforeignkey, |
| + | ct dforeignkey, | ||
dtncu | dtncu | ||
dtcurr | dtcurr | ||
| Строка 39: | Строка 40: | ||
CREATE TABLE a2_some_doc_line ( | CREATE TABLE a2_some_doc_line ( | ||
| − | id | + | id dintkey, |
| − | + | masterdockey dintkey, | |
| + | docorder dinteger, | ||
| + | [attr1] | ||
| + | ... | ||
| + | [attrn] | ||
); | ); | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Версия 19:02, 24 октября 2016
CREATE TABLE a2_entry ( id dintkey, masterentrykey dforeignkey, companykey dintkey, entrydate dtimestamp_notnull, dt dforeignkey, ct dforeignkey, dtncu dtcurr dtcurrkey dteq ctncu ctcurr ctcurrkey cteq doctypekey dockey bpseq prevkey firstkey creationdate creatorkey editiondate editorkey aview achag afull ); CREATE TABLE a2_some_doc ( id dintkey, docnumber ddocnumber, [attr1] ... [attrn] ); CREATE TABLE a2_some_doc_line ( id dintkey, masterdockey dintkey, docorder dinteger, [attr1] ... [attrn] );