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)