개발동아리관리부DB

테이블 (7)

Book (Untitled3)

  • bookid (Key) — VARCHAR — 기본 키 — NOT NULL
  • bname (Field) — VARCHAR
  • Field2 — VARCHAR
  • author (Field3) — VARCHAR
  • bstate (Field4) — VARCHAR
  • donor (Field5) — VARCHAR

BookRental (Untitled5)

  • brentid (Key) — VARCHAR — 기본 키 — NOT NULL
  • rentdate (Field) — DATE
  • duedate (Field2) — DATE
  • retdate (Field3) — DATE
  • rentstatus (Field4) — VARCHAR

EquipRental (Untitled4)

  • erentid (Key) — VARCHAR — 기본 키 — NOT NULL
  • rentdate (Field) — DATE
  • duedate (Field2) — DATE
  • retdate (Field3) — DATE
  • rentstatus (Field4)

Equipment (Untitled7)

  • equid (Key) — VARCHAR — 기본 키 — NOT NULL
  • ename (Field) — VARCHAR
  • equqty (Field2) — INT
  • eloc (Field3) — VARCHAR
  • estate (Field4) — VARCHAR

Meeting (Untitled6)

  • meetid (Key) — VARCHAR — 기본 키 — NOT NULL
  • meetdate (Field) — DATE
  • subject (Field2) — VARCHAR
  • attendcnt (Field3) — INT
  • writer (Field4) — VARCHAR

Member (Untitled2)

  • memgen (Key) — VARCHAR — 기본 키 — NOT NULL
  • mname (Field) — VARCHAR
  • dept (Field2) — VARCHAR
  • grade (Field3) — INT
  • phone (Field4) — VARCHAR

Untitled

  • Key — 기본 키 — NOT NULL
  • Field