%syntax-version=1.0.0 %project=kakeibo %uri=http://http//git.private.tojo.tokyo/kakeibo.git appschema 2023-02-26T06:27:59Z Masaya Tojo # Add schema for all kakeibo objects. transaction_type [appschema] 2023-02-27T15:51:38Z Masaya Tojo # Add transaction type. transactions [appschema transaction_type] 2023-02-27T15:53:02Z Masaya Tojo # Add table for tracking transactions. insert_transaction [appschema transactions] 2023-02-28T01:06:21Z Masaya Tojo # Add function to insert transaction. delete_transaction [transactions appschema] 2023-02-28T12:00:07Z Masaya Tojo # Create a function to delete a transaction. items [appschema transactions] 2023-02-28T12:08:45Z Masaya Tojo # Add items table for tracking individual products in transaction. insert_item [appschema items] 2023-02-28T13:13:22Z Masaya Tojo # Add function to insert item. delete_item [appschema items] 2023-02-28T13:13:39Z Masaya Tojo # Add function to delete item. update_timestamp [appschema] 2023-02-28T14:30:04Z Masaya Tojo # Add triger function to update a timestamp. transactions_update_timestamp [transactions update_timestamp] 2023-02-28T16:43:49Z Masaya Tojo # Add update_timestamp trigger to transactions table.