python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - database-schema

Keep track of quantity and some columns in multiple tables

I'm trying to build a farm management app with Laravel and I need help with my database schema. Here are some of my tables users (id, name) products (id, trade_name, state, category_id) expenses (id, ...
test-img

Othmane

laravel

database

schema

database-schema

Votes: 0

Answers: 1

Latest Answer

You can create a stock table if you know that this table will only use for product and equipements: id stockable_id stockable_type quantity total_distance_traveled // nullable as they have value only ...
test-img

Muhammad Shareyar

Different Schema name for SQL datasets in ADF using parameters

We have tables under different schema in same db in Azure SQL DB. eg. QA.Mytable and Prod.Mytable . so to manage this in Azure data factory for different environments, is there any way ? or is it bett...
test-img

Prathamesh

sql

parameters

dataset

azure-data-factory

database-schema

Votes: 0

Answers: 1

Latest Answer

@Agratu : You won't be able to use Global Parameters in a dataset, you can use them in an activity inside an ADF pipeline Also, I would recommend to separate databases for each environment as a best p...
test-img

Pratik Somaiya

Does the order of keys in a primary key array matter?

We've got a distributed/sharded database, so we use a combination of id and partner_id (which is our partition ID) as the primary key on any of our distributed tables. In my schema.rb file, this decla...
test-img

jeffdill2

ruby-on-rails

postgresql

ruby-on-rails-5

database-schema

Votes: 0

Answers: 2

Latest Answer

A test case: create table pk_test1 (id integer, id2 integer, primary key(id, id2)); create table pk_test1 (id integer, id2 integer, primary key(id2, id)); \d pk_test Table "public....
test-img

Adrian Klaver

Dynamodb design recommendations for partial comparisons

I currently have a Dynamodb table with the following columns - Id (Partition Key), NativeTimestampAndPath (Range Key), EntryTimestamp (Attribute). No secondary indexes as of now. Sample data looks lik...
test-img

activelearner

database-design

amazon-dynamodb

database-schema

dynamodb-queries

database-indexes

Votes: 0

Answers: 1

Latest Answer

Right, the sort key is going to be treated as a string. Is 1970-01-01T00:00:00Z#event/event_name=event_1/event_type=type=1/day=16/eventid1-file2.json less than or equal to 1970-01-01T00:00:00Z? No, it...
test-img

hunterhacker

Posts

Questions

Blogs

Jobs