I have a DDD setup in C#, linking entities to DB tables. An entity has a configured Id (primary key) that encapsulates a non-negative, non-zero integer (a value object). I have the primary key configured in EF Core fluent API,…
CREATE TABLE `test` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `month` timestamp NOT NULL DEFAULT '2018-01-01 00:00:00', `b` varchar(255) NOT NULL DEFAULT '', `c` varchar(255) NOT NULL DEFAULT '', `d` varchar(255) NOT NULL DEFAULT '', `e` varchar(255) NOT NULL DEFAULT…
Consider the following table, recipe, in a PostgreSQL database. Column Type Collation Nullable Default name text not null date date not null ingredients text[] not null calories integer not null Assume a user wanted to add a new recipe to…
I refresh my indexes in my Postgresql database with the "reindex index concurrently" command. However, I never renewed my primary key indexes because it might damage my primary key indexes or cause problems. My question is: Is there any harm…
I have a table for the invoice and it has the primary key which is id, and for invoice details the foreign key is invoice_id. What I want is during saving the primary key on the invoice, it would also…
I have two MySQL tables. One is a large list of entries which is basically the main table. The second is a table of pending entries, that will ultimately get added to the large list of entries if they're approved…
I am trying to auto increment a table with a single column which is a primary key, eg: CREATE TABLE my_table (id PRIMARY KEY NOT NULL); I would usually just not include the primary key column in the insert statment…
For our new MySQL database, we are thinking of using UUID as the primary key stored as BINARY(16). The key values would be generated by the the below function in Java application, or by UUID_TO_BIN(UUID()) built-in functions in data loads…
I'm learning from an online course MySQL using the WampServer and editing code in MySQL Workbench. Trying to create a table with the following code, the column nome appears to be the primary key from the table, but i'm only…
I am designing a sharded database. Many times we use two columns, first for logical shard and second for uniquely identifying a row in the shard. Instead of that I am planning to have just a 1 column with long…