forked from yaperos/app-java-codechallenge
- Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinit.sql
More file actions
Latest commit
11 lines (11 loc) · 434 Bytes
/
Copy pathinit.sql
File metadata and controls
11 lines (11 loc) · 434 Bytes
1
2
3
4
5
6
7
8
9
10
11
CREATETABLETransactions (
transactionExternalId VARCHAR(36) PRIMARY KEY,
accountExternalIdDebit VARCHAR(255) NOT NULL,
accountExternalIdCredit VARCHAR(255) NOT NULL,
transferTypeId INTNOT NULL,
value NUMERICNOT NULL,
transactionType VARCHAR(255) NULL,
transactionStatus VARCHAR(255) NOT NULL,
createdAt TIMESTAMPNOT NULL
);
CREATEINDEXidx_transactions_idON Transactions (transactionExternalId);