myPlace

Tables (4)

BOARD (Untitled2)

  • BOARD_NUM (NUM) — NUMBER(20) — Primary key — NOT NULL
  • BOARD_WRITER (WRITER) — VARCHAR2(100)
  • BOARD_CONTENT (CONTENT) — VARCHAR2(400)
  • BOARD_DATE (DATE) — DATE
  • BOARD_DEL_GB (DEL_GB) — VARCHAR2(2)
  • BOARD_TITLE (TITLE) — VARCHAR2(100)
  • BOARD_PLACE (PLACE) — NUMBER(20)
  • MEM_NUM (NUM2) — NUMBER(20) — Foreign key → MEMBER.MEM_NUM — NOT NULL
  • MEM_ID (ID) — VARCHAR2(100) — Foreign key → MEMBER.MEM_ID — NOT NULL
  • MEM_EMAIL (EMAIL) — VARCHAR2(100) — Foreign key → MEMBER.MEM_EMAIL — NOT NULL

LIKEPLACE (Untitled3)

  • LIKEPLACE_MEM (MEM) — VARCHAR2(100)
  • LIKEPLACE_PLACE (PLACE) — NUMBER(20)
  • LIKEPLACE_DATE (DATE) — DATE
  • MEM_NUM (NUM) — NUMBER(20) — Foreign key → MEMBER.MEM_NUM — NOT NULL
  • MEM_ID (ID) — VARCHAR2(100) — Foreign key → MEMBER.MEM_ID — NOT NULL
  • MEM_EMAIL (EMAIL) — VARCHAR2(100) — Foreign key → MEMBER.MEM_EMAIL — NOT NULL
  • PLACE_NUM (NUM2) — NUMBER(20) — Foreign key → PLACE.PLACE_NUM — NOT NULL

MEMBER (Untitled)

  • MEM_NUM (NUM) — NUMBER(20) — Primary key — NOT NULL
  • MEM_ID (ID) — VARCHAR2(100) — Primary key — NOT NULL
  • MEM_EMAIL (EMAIL) — VARCHAR2(100) — Primary key — NOT NULL
  • MEM_PW (PW) — VARCHAR2(100)
  • MEM_NAME (NAME) — VARCHAR2(20)
  • MEM_PHONE (PHONE) — VARCHAR2(11)
  • MEM_DEL_GB (DEL_GB) — VARCHAR2(2)
  • MEM_DEL_TIME (DEL_TIME) — -
  • MEM_ADMIN (ADMIN) — VARCHAR2(2)

PLACE (Untitled4)

  • PLACE_NUM (NUM) — NUMBER(20) — Primary key — NOT NULL
  • PLACE_LNG (LNG) — VARCHAR2(100)
  • PLACE_DATE (DATE) — DATE
  • PLACE_ADDR (ADDR) — VARCHAR2(100)
  • PLACE_NAME (NAME) — VARCHAR2(100)
  • PLACE_TYPE (TYPE) — VARCHAR2(100)
  • PLACE_LAT (LAT) — VARCHAR2(100)
  • PLACE_TEL (TEL) — VARCHAR2(20)
  • PLACE_MENU (MENU) — VARCHAR2(100)
  • BOARD_NUM (NUM2) — NUMBER(20) — Foreign key → BOARD.BOARD_NUM — NOT NULL