Forum OpenACS Q&A: Re: An fk (from my table to apm_packages) issue maybe?

create table websites
(
    site_id integer
      constraint sts__site_id__pk
        primary key
      constraint sts__site_id__acs_objects_fk
        references acs_objects(object_id)
      on delete cascade,
    -- associate with which package instance, so that each page can quickly determine site
    package_id integer
      constraint ws__package_id__un
        unique
      constraint ws__package_id__nn
        not null
      constraint ws__package_id__acs_objects__fk
        references acs_objects(object_id)
      on delete cascade
)