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