myPlace
Tables (3)
BOARD (Untitled)
- BOARD_NUM (PK) — NUMBER(20) — Primary key — NOT NULL
- BOARD_WRITER (FK1) — VARCHAR2(100)
- BOARD_CONTENT (Field) — VARCHAR2(400)
- BOARD_DATE (Field2) — DATE
- BOARD_DEL_GB (Field3) — VARCHAR2(2)
- BOARD_TITLE (Field4) — VARCHAR2(100)
- BOARD_PLACE (FK2) — NUMBER(20)
- MEM_NUM (PK2) — NUMBER(20) — Foreign key → MEMBER.MEM_NUM — NOT NULL
- LIKEPLACE_PLACE (PK3) — VARCHAR2(20) — Foreign key → LIKEPLACE.LIKEPLACE_PLACE
LIKEPLACE (Untitled3)
- LIKEPLACE_PLACE (PK) — VARCHAR2(20) — Primary key
- LIKEPLACE_MEM (Field) — VARCHAR2(20)
- LIKEPLACE_DATE (Field2) — DATE
- LIKEPLACE_LAT (Field3) — VARCHAR2(50)
- LIKEPLACE_NAME (Field4) — VARCHAR2(50)
- LIKEPLACE_LNG (Field5) — NUMBER(20)
- LIKEPLACE_ADDR (Field6) — VARCHAR2(100)
MEMBER (Untitled2)
- MEM_NUM (PK) — NUMBER(20) — Primary key — NOT NULL
- MEM_ID (UNIQUE1) — NUMBER(20)
- MEM_EMAIL (UNIQUE2) — VARCHAR2(100)
- MEM_PW (Field) — VARCHAR2(100)
- MEM_NAME (Field1) — VARCHAR2(20)
- MEM_PHONE (Field2) — VARCHAR2(11)
- MEM_DEL_GB (Field3) — VARCHAR2(2)
- MEM_DEL_TIME (Field4) — DATE
- MEM_ADMIN (Field5) — VARCHAR2(2)