I'm making a competitive two player game and after each game I store a record of that game that includes the score, player names and the date. I would like that if one of the users deletes their account the…
I have a product system that each category can have multiple subcategory layers if there aren't any products attached to them, and we can attach as many products as we want to a category if there aren't any sub-categories attached…
Description So, I'm working on a project that stores sensor measurements from multiple devices in PostgreSQL+TimescaleDB database. The structure of the table (hypertable): column_name type comment identifier text device identifier key text name of the metric value_num double precision numeric…
I have a database of polymorphic structure: a "base" type table and two "derived" types: CREATE TABLE ContactMethod( id integer PRIMARY KEY person_id integer priority integer allow_solicitation boolean FOREIGN KEY(person_id) REFERENCES People(id) ) CREATE TABLE PhoneNumbers( contact_method_id integer PRIMARY KEY…
The central database(blue) will hold all customer data of the project. The local databases(green) will be deployed at the physical locations containing a copy of the customer databases. Multiple stores can be deployed across geographical areas (A, B,...N) to allow…
I have a single dynamodb table. One of the type records is called "Result" and one of its PK stores a composite key (class, student and exercise). This is the example design: PK SK SCORE ... GSI PK 1 GSI…
everyone. I'm learning Laravel and I'm in the start of my journey. I was learning about encryption and decryption in Laravel today and then this thought came into my mind. Could be a stupid one but I want to know…
I find myself designing a database for a system for registering orders for a pizzeria. I have a table called "products" that contains these attributes: | PRODUCTS | | --------------------- | | id | int | | name | varchar…
I am new to Firestore and building an event planning app but I am unsure what the best way to structure the data is taking into account the speed of queries and Firestore costs based on reads etc. In both…
How can I create a relationship in EF core where the child(FullName) table has DrugId which is the primary key. In the parent table(Basic Data), DrugId is foreign key. But there are other child tables and they are also referring…