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