WebProject

Tables (4)

Board (Untitled3)

  • id (Key) — varchar(200) — Primary key — NOT NULL
  • id (Key2) — varchar(200) — Foreign key → Member.id — NOT NULL
  • title (Field) — varchar(200)
  • content (Field2) — varchar(200)
  • num (Field3) — number(10)
  • postdate (Field4) — sysdate
  • visitcount (Field5) — number(10)
  • name (Field6) — varchar(200)

Data (Untitled)

  • lat — number(15,10) — Primary key — NOT NULL
  • instl_floor (Field) — varchar(200)
  • instl_mby (Field2) — varchar(200)
  • mgr_no (Field3) — varchar(200)
  • svc_se (Field4) — varchar(200)
  • wrdofc (Field5) — varchar(200)
  • cmcwr (Field6) — varchar(200)
  • instl_ty (Field7) — varchar(200)
  • adres2 (Field8) — varchar(200)
  • adres1 (Field9) — varchar(200)
  • work_dttm (Field10) — varchar(200)
  • lnt (Field11) — varchar(200)
  • inout_door (Field12) — varchar(200)
  • main_nm (Field13) — varchar(200)
  • remars3 (Field14) — varchar(200)
  • cnstc_year (Field15) — varchar(200)

Member (Untitled4)

  • id (Key) — varchar(200) — Primary key — NOT NULL
  • pass (Field) — varchar(200)
  • name (Field2) — varchar(200)
  • regidate (Field3) — sysdate

Search (Untitled2)

  • lat (Key) — number(15,10) — Primary key — NOT NULL
  • lat (2) — number(15,10) — Foreign key → Data.lat — NOT NULL
  • lnt (Field) — number(15,10)
  • date (Field2)