github.com/voedger/voedger@v0.0.0-20240520144910-273e84102129/examples/airs-bp/air/air.vsql (about)

     1  -- Copyright (c) 2024-present unTill Software Development Group B. V.
     2  -- @author Maxim Geraskin
     3  
     4  IMPORT SCHEMA 'github.com/untillpro/airs-scheme/bp3' AS untill;
     5  
     6  APPLICATION app(
     7      USE untill;
     8  );
     9  
    10  WORKSPACE RestaurantWS (
    11  
    12  	TABLE ProformaPrinted INHERITS ODoc (
    13  		Number int32 NOT NULL,
    14  		UserID ref(untill.untill_users) NOT NULL,
    15  		Timestamp int64 NOT NULL,
    16  		BillID ref(untill.bill) NOT NULL
    17  	);
    18  
    19  	VIEW PbillDates (
    20  		Year int32 NOT NULL,
    21  		DayOfYear int32 NOT NULL,
    22  		FirstOffset int64 NOT NULL,
    23  		LastOffset int64 NOT NULL,
    24  		PRIMARY KEY ((Year), DayOfYear)
    25  	) AS RESULT OF FillPbillDates;
    26  
    27  	EXTENSION ENGINE BUILTIN (
    28  	    COMMAND Orders(untill.orders);
    29  	    COMMAND Pbill(untill.pbill) RETURNS CmdPBillResult;
    30  	);
    31  )