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)