SOCIAL SERVICE

Tables (5)

AGENT (Untitled4)

  • a_# (Key) — INT(20) — Primary key — NOT NULL
  • a_name (Field) — VARCHAR(30)
  • a_address (Field2) — VARCHAR(100)
  • a_ph (Field3) — INT(11)

CUSTOMER (Untitled2)

  • c_id (Key) — INT(13) — Primary key — NOT NULL
  • c_name (Field) — VARCHAR(30)
  • c_address (Field2) — VARCHAR(100)
  • c_ph (Field3) — INT(11)

DEPENDENT (Untitled3)

  • d_id (Key) — INT(13) — Primary key — NOT NULL
  • d_name (Field) — VARCHAR(30)
  • d_age (Field2) — INT(3)
  • c_id (Key2) — INT(13) — Foreign key → CUSTOMER.c_id — NOT NULL

ENROLL-SERVICE (Untitled)

  • c_id (Key) — INT(13) — Primary key — NOT NULL
  • s_code (Key2) — CHAR(30) — Primary key — NOT NULL
  • c_id (Key3) — INT(13) — Foreign key → CUSTOMER.c_id — NOT NULL

SERVICE (Untitled5)

  • s_code (Key) — CHAR(20) — Primary key — NOT NULL
  • exp (Field) — VARCHAR(100)
  • s_date (Field2) — DATETIME