23
Tables (10)
Customer
- cid (Key) — int(10) — Primary key — NOT NULL
- name (Field) — str(10)
- address (Field2) — str(30)
- phonenum (Field3) — int(20)
Customerfamily
- famid (Key) — int(10) — Primary key — NOT NULL
- famname (Field) — str(10)
- age (Field2) — int(10)
- id (Key2) — int(10) — Foreign key → Customer.cid — NOT NULL
Lecturer
- lecturerid (Key) — int — Primary key — NOT NULL
- lname (Field) — str(10)
- phone (Field2) — int
- address (Field3) — str(30)
- grade (Field4) — str(10)
- description (Field5) — text
Registeredclass (Register)
- membercode (Key) — int(10) — Foreign key → member.membercode — NOT NULL
- classcode (Key2) — int(10) — Foreign key → class.classcode — NOT NULL
Service
- servicecode (Key) — int(10) — Primary key — NOT NULL
- explanation (Field) — str(30)
Service_provide
- cid (Key) — int(10) — Foreign key → Customer.cid — NOT NULL
- spcode (Key2) — int(10) — Foreign key → Serviceprovider.spcode — NOT NULL
- date (Field) — date
Serviceprovider (Untitled)
- spcode (Key) — int(10) — Primary key — NOT NULL
- spname (Field) — str(10)
- spaddress (Field2) — str(30)
- spphonenum (Field3) — int(20)
- servicecode (Key2) — int(10) — Foreign key → Service.servicecode — NOT NULL
Sports
- sportscode (Key) — int(10) — Primary key — NOT NULL
- explanation (Field) — text
- name (Field2) — str(10)
class (Class)
- classcode (Key) — int(10) — Primary key — NOT NULL
- time (Field) — str(20)
- sportscode (Key2) — int(10) — Foreign key → Sports.sportscode — NOT NULL
- limitpplnum (Field2) — int(10)
- registerednum (Field3) — int(10)
- classname (Field4) — str(10)
- level (Field5) — str(10)
- lecturerid (Key3) — int — Foreign key → Lecturer.lecturerid — NOT NULL
member (Member)
- membercode (Key) — int(10) — Primary key — NOT NULL
- address (Field) — str(30)
- age (Field2) — int(10)
- name (Field3) — str(10)