kaoni_ksj

Tables (5)

BOARD (Untitled4)

  • NBO (Key) — VARCHAR2 — Primary key — NOT NULL
  • EMnum (Key2) — VARCHAR2 — Foreign key → Member.EMnum — NOT NULL
  • TITLE (Field2) — VARCHAR2
  • CONTENT (Field3) — VARCHAR2
  • REGDATE (Field4) — VARCHAR2
  • UPDATEDATE (Field5) — DATE
  • IMPOR (Field6) — NUMBER
  • Field7

MAIN (Untitled5)

  • MAINNUM (Key) — VARCHAR2 — Primary key — NOT NULL
  • ISOLEMEMBER (Field) — NUMBER
  • NOWMEMBER (Field2) — NUMBER
  • MEMBER (Field3) — NUMBER
  • INSERTDATE (Field4) — DATE

Member (Untitled)

  • EMnum (Key) — VARCHAR2 — Primary key — NOT NULL
  • NAME (Field) — VARCHAR2 — NOT NULL
  • POSITION (Field2) — VARCHAR2
  • ID (Field3) — VARCHAR2
  • PASSWD (Field4) — VARCHAR2
  • GENDER (Field5) — VARCHAR2
  • DNAME (Field6) — VARCHAR2

PCR (Untitled2)

  • PNUM (Key) — VARCHAR2 — Primary key — NOT NULL
  • EMnum (Key2) — VARCHAR2 — Foreign key → Member.EMnum — NOT NULL
  • POUTCMOE (Field2) — VARCHAR2
  • ISOLEA (Field3) — DATE
  • ISOLEB (Field4) — DATE
  • PCONTENT (Field5) — VARCHAR2
  • DELETEYN (Field6)

SELF (Untitled3)

  • EMnum (Key2) — VARCHAR2 — Foreign key → Member.EMnum — NOT NULL
  • SELFCHECK1 (Field) — VARCHAR2
  • SELFCHECK2 (Field2) — VARCHAR2
  • SELFCHECK3 (Field3) — VARCHAR2
  • SELFCHECK4 (Field4) — VARCHAR2
  • SELFCHECK5 (Field5) — VARCHAR2
  • SELFCHECK6 (Field6) — VARCHAR2
  • SELFCHECK7 (Field7) — VARCHAR2
  • DELETEYN (Field8) — VARCHAR2
  • Field9