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)