PS

Tables (10)

CLASS (Untitled3)

  • CID (Key) — LONG — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(50)
  • GRADE (Field2) — LONG
  • PROFESSOR (Field3) — LONG
  • UID (Key2) — LONG — Foreign key → USER.UID — NOT NULL

CLUB (Untitled4)

  • CID (Key) — LONG — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(20)
  • UID (Key2) — LONG — Foreign key → USER.UID — NOT NULL

CLUBKIND (Untitled9)

  • KID (Key) — LONG — Primary key — NOT NULL
  • KIND (Field) — VARCHAR(1)
  • CID (Key2) — LONG — Foreign key → CLUB.CID — NOT NULL

DEPARTMENT (Untitled6)

  • DID (Key) — LONG — Primary key — NOT NULL
  • DEPNUMBER (Field) — LONG
  • NAME (Field2) — VARCHAR(30)
  • PROFESSOR (Field3) — LONG
  • UID (Key2) — LONG — Foreign key → USER.UID — NOT NULL

IMGCODE (Untitled10)

  • IID (Key) — LONG — Primary key — NOT NULL
  • FILE (Field) — FILE
  • UID (Key2) — LONG — Foreign key → USER.UID — NOT NULL

NOTICE (Untitled2)

  • NID (Key) — LONG — Primary key — NOT NULL
  • TARGET (Field) — VARCHAR(30)
  • TITLE (Field2) — VARCHAR(30)
  • BODY (Field3) — VARCHAR(100)
  • FILE (Field4) — FILE
  • UID (Key2) — LONG — Foreign key → USER.UID — NOT NULL

POSITION (Untitled8)

  • PID (Key) — LONG — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(10)
  • UID (Key2) — LONG — Foreign key → USER.UID — NOT NULL

SCHEDULE (Untitled5)

  • SID (Key) — LONG — Primary key — NOT NULL
  • START (Field) — DATE
  • END (Field2) — DATE
  • BODY (Field3) — VARCHAR(30)
  • NID (Key2) — LONG — Foreign key → NOTICE.NID — NOT NULL

SCHOOL (Untitled7)

  • SID (Key) — LONG — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(20)
  • UID (Key2) — LONG — Foreign key → USER.UID — NOT NULL

USER (Untitled)

  • UID (Key) — LONG — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(12)
  • EMAIL (Field2) — VARCHAR(30)
  • PASSWORD (Field6) — VARCHAR(30)