myPlace
Tables (4)
Untitled (MEMBER)
- Key (MEM_NUM) — NUMBER(20) — Primary key — NOT NULL
- Field2 (MEM_ID) — VARCHAR2(100)
- Field3 (MEM_EMIAL) — VARCHAR2(100)
- Field4 (MEM_PW) — VARCHAR2(100)
- Field5 (MEM_NAME) — VARCHAR2(20)
- Field (MEM_PHONE) — VARCHAR(11)
- Field (MEM_DEL_GB) — VARHAR2(2)
- Field (MEM_DEL_TIME) — -
- Field (MEM_ADMIN) — VARCHAR(2)
Untitled2 (LIKEPLACE)
- Field (LIKEPLACE_MEM) — VARCHAR2(100)
- Field2 (LIKEPLACE_PLACE) — NUMBER(20)
- Field3 (LIKEPLACE_DATE) — DATE
- Key (MEM_NUM) — NUMBER(20) — Foreign key → Untitled.Key — NOT NULL
- Key (PLACE_NUM) — NUMBER(20) — Foreign key → Untitled4.Key — NOT NULL
Untitled3 (BOARD)
- Key (BOARD_NUM) — NUMBER(20) — Primary key — NOT NULL
- Field (BOARD_WRITER) — VARCHAR2(100)
- Field (BOARD_CONTENT) — VARCHAR2(400)
- Field (BOARD_DATE) — DATE
- Field (BOARD_DEL_GB) — VARCHAR2(2)
- Field (BOARD_TITLE) — VARCHAR2(100)
- Field (BOARD_PLACE) — NUMBER(20)
- Key (MEM_NUM) — NUMBER(20) — Foreign key → Untitled.Key — NOT NULL
Untitled4 (PLACE)
- Key (PLACE_NUM) — NUMBER(20) — Primary key — NOT NULL
- Field (PLACE_LNG) — VARCHAR2(100)
- Field (PLACE_DATE) — DATE
- Field (PLACE_ADDR) — VARCHAR2(100)
- Field (PLACE_NAME) — VARCHAR2(100)
- Field (PLACE_TYPE) — VARCHAR2(100)
- Field (PLACE_LAT) — VARCHAR2(100)
- Field (PLACE_TEL) — VARCHAR2(20)
- Field (PLACE_MENU) — VARCHAR2(100)
- Key (BOARD_NUM) — NUMBER(20) — Foreign key → Untitled3.Key — NOT NULL