SQL_TEAMPROJECT_sub(SUB)

Tables (11)

Company (Untitled5)

  • CompanyId (Key) — int(11) — Primary key — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(100)
  • Fax (Field3) — char(20)
  • email (Field4) — char(20)
  • homepage (Field5) — text

Content (Untitled4)

  • contentId (Key) — int(11) — Primary key — NOT NULL
  • name (Field) — char(50)

Payment (Untitled6)

  • pId (Key) — int(11) — Primary key — NOT NULL
  • pName (Field) — char(30)

Subscription (Untitled2)

  • subscriptionId (Key) — int(11) — Primary key — NOT NULL
  • name (Field) — char(50)
  • contentId (Key2) — int(11) — Foreign key → Content.contentId — NOT NULL
  • price (Field2) — int(7)
  • CompanyId (Key3) — int(11) — Foreign key → Company.CompanyId — NOT NULL
  • period (Field3) — iint(4)
  • benefit (Field4) — text

Subscription_Payment (Untitled7)

  • pId (Key) — int(11) — Foreign key → Payment.pId — NOT NULL
  • subscriptionId (Key2) — int(11) — Foreign key → Subscription.subscriptionId — NOT NULL
  • information (Field) — text
  • startDate (Field3) — date
  • endDate (Field4) — date
  • paymentBenefit (Field2) — int(7)

Subscription_telecom (Untitled9)

  • subscriptionId (Key2) — int(11) — Foreign key → Subscription.subscriptionId — NOT NULL
  • TelecomId (Key) — int(11) — Foreign key → Telecom.telecomId — NOT NULL
  • telecomBenefit (Field) — int(8)
  • enroll (Field2) — enum('Y', 'N')

Telecom (Untitled8)

  • telecomId (Key) — int(11) — Primary key — NOT NULL
  • telecomName (Field) — char(20)

USER (Untitled)

  • userId (Key) — int(11) — Primary key — NOT NULL
  • name (Field) — char(20)
  • phone (Field2) — char(14)
  • email (Field3) — char(30)
  • telecomId (Key2) — int(11) — Foreign key → Telecom.telecomId — NOT NULL
  • gender (Field4) — chr(3)
  • phonePlan (Field5) — int(7)

User_Payment (Untitled10)

  • pId (Key2) — int(11) — Foreign key → Payment.pId — NOT NULL
  • userId (Key) — int(11) — Foreign key → USER.userId — NOT NULL

User_Subscription (Untitled3)

  • key (Key3) — int(11) — Primary key — NOT NULL
  • subscriptionId (Key2) — int(11) — Foreign key → Subscription.subscriptionId — NOT NULL
  • userId (Key) — int(11) — Foreign key → User_Payment.userId — NOT NULL
  • subscriptionStartDate (Field) — date
  • RenewalDate (Field2) — date
  • pId (Key22) — int(11) — Foreign key → User_Payment.pId — NOT NULL
  • paymentPrice (Field3) — int(7)

User_using (Untitled11)

  • timeRecordId (Key3) — Primary key — NOT NULL
  • userId (Key) — int(11) — Foreign key → USER.userId — NOT NULL
  • subscriptionId (Key2) — int(11) — Foreign key → Subscription.subscriptionId — NOT NULL
  • Date (Field) — date
  • day (Field3) — int(8)
  • usingTime (Field2) — int(8)