myPlace

Tables (3)

BOARD (Untitled2)

  • BOARD_NUM (PK) — NUMBER(20) — Primary key — NOT NULL
  • BOARD_WRITER (FK) — VARCHAR2(100)
  • BOARD_CONTENT (Field) — VARCHAR2(400)
  • BOARD_DATE (Field2) — DATE
  • BOARD_DEL_GB (Field3) — VARCHAR2(2)
  • BOARD_TITLE (Field4) — VARCHAR2(100)
  • BOARD_PLACE (FK1) — VARCHAR2(20)
  • MEM_NUM (-) — NUMBER — Foreign key → MEMBER.MEM_NUM — NOT NULL
  • LIKEPLACE_PLACE (PK2) — VARCHAR2(20) — Foreign key → LIKEPLACE.LIKEPLACE_PLACE — NOT NULL

LIKEPLACE (Untitled3)

  • LIKEPLACE_PLACE (PK) — VARCHAR2(20) — Primary key — NOT NULL
  • LIKEPLACE_MEM (Field) — VARCHAR2(20)
  • LIKEPLACE_DATE (Field2) — DATE
  • LIKEPLACE_LAT (Field3) — VARCHAR2(50)
  • LIKEPLACE_NAME (Field4) — VARCHAR2(50)
  • LIKEPLACE_LNG (Field5) — VARCHAR2(50)
  • LIKEPLACE_ADDR (Field6) — VARCHAR2(100)
  • LIKEPLACE_STATE (Field7) — VARCHAR2(2)

MEMBER (Untitled)

  • MEM_NUM (PK) — NUMBER — Primary key — NOT NULL
  • MEM_ID (UNIQUE) — VARCHAR2(100)
  • MEM_EMAIL (UNIQUE2) — VARCHAR2(100)
  • MEM_PW (Field) — VARCHAR2(100)
  • MEM_NAME (Field2) — VARCHAR2(20)
  • MEM_PHONE (Field3) — VARCHAR2(11)