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)