Is "id" a mandatory field for all tables ?
# orm-helps
shashank
10/02/2018, 8:44 AMIs "id" a mandatory field for all tables ?
n
nilan
10/02/2018, 8:45 AM@shashank let's continue the conversation in this thread 🙂
nilan
10/02/2018, 8:45 AMno,
idids
shashank
10/02/2018, 8:47 AMI don't want to use 'id' for all tables .
n
nilan
10/02/2018, 8:48 AMYou don't have to.
s
shashank
10/02/2018, 8:48 AMI was generating prisma model from existing postgres model
shashank
10/02/2018, 8:48 AMcreate table alert_offer
(
sale_alert_id bigint not null
constraint fkkalfe7keier2t8lv4mpr8dtjr
references sale_alert
on update restrict on delete restrict,
offer_id bigint not null
constraint fkeg0evpjnarifhv4cbs339lqn9
references checkoutoffer
on update restrict on delete restrict,
constraint idx_404828_primary
primary key (sale_alert_id, offer_id)
);
create index idx_404828_fkeg0evpjnarifhv4cbs339lqn9
on alert_offer (offer_id);
n
nilan
10/02/2018, 8:49 AMI suggest you share a reproducible bug report here, so we can figure out what the problem is: https://github.com/prisma/prisma/issues/new?template=bug_report.md
s
shashank
10/02/2018, 8:49 AMAbove model defines the model which is giving the error
"Alert_offer
✖️ The required field
idshashank
10/02/2018, 8:53 AMThis the schema created by prisma introspect
shashank
10/02/2018, 8:55 AM@nilan will add to github . But do have a look at schema created by prisma.
👍 1
shashank
10/02/2018, 8:59 AMshashank
10/02/2018, 9:22 AMIf I am not wrong I see the reason for failing my model is
"fail if a model does not specify an id field at all for a passive connector" in {
val schema =
"""
|type Todo {
| title: String
|}
""".stripMargin
val result = SchemaSyntaxValidator(schema, isActive = false).validate
val error1 = result.head
error1.
typeid4 Views