123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116 |
- <?php
- namespace Component\Bridge\Entity;
- use DateTimeInterface;
- class ForeignSubscription
- {
-
- private int $service;
- private int $subscriber;
- private int $subscribed;
- private DateTimeInterface $created;
- public function setService(int $service): self
- {
- $this->service = $service;
- return $this;
- }
- public function getService(): int
- {
- return $this->service;
- }
- public function setSubscriber(int $subscriber): self
- {
- $this->subscriber = $subscriber;
- return $this;
- }
- public function getSubscriber(): int
- {
- return $this->subscriber;
- }
- public function setSubscribed(int $subscribed): self
- {
- $this->subscribed = $subscribed;
- return $this;
- }
- public function getSubscribed(): int
- {
- return $this->subscribed;
- }
- public function setCreated(DateTimeInterface $created): self
- {
- $this->created = $created;
- return $this;
- }
- public function getCreated(): DateTimeInterface
- {
- return $this->created;
- }
-
- public static function schemaDef(): array
- {
- return [
- 'name' => 'foreign_subscription',
- 'fields' => [
- 'service' => ['type' => 'int', 'not null' => true, 'description' => 'service where relationship happens'],
- 'subscriber' => ['type' => 'int', 'size' => 'big', 'not null' => true, 'description' => 'subscriber on foreign service'],
- 'subscribed' => ['type' => 'int', 'size' => 'big', 'not null' => true, 'description' => 'subscribed user'],
- 'created' => ['type' => 'datetime', 'not null' => true, 'default' => 'CURRENT_TIMESTAMP', 'description' => 'date this record was created'],
- ],
- 'primary key' => ['service', 'subscriber', 'subscribed'],
- 'foreign keys' => [
- 'foreign_subscription_service_fkey' => ['foreign_service', ['service' => 'id']],
- 'foreign_subscription_subscriber_fkey' => ['foreign_user', ['subscriber' => 'id', 'service' => 'service']],
- 'foreign_subscription_subscribed_fkey' => ['foreign_user', ['subscribed' => 'id', 'service' => 'service']],
- ],
- 'indexes' => [
- 'foreign_subscription_subscriber_idx' => ['service', 'subscriber'],
- 'foreign_subscription_subscribed_idx' => ['service', 'subscribed'],
- ],
- ];
- }
- }
|