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)