MYGYM
Tables (10)
BICYCLE (Untitled2)
- BIC_SEQ (Key) — NUMBER — Primary key — NOT NULL
- BIC_TOWN (Field) — VARCHAR2(128)
- BIC_NAME (Field2) — VARCHAR2(300)
- BIC_ADDR (Field3) — VARCHAR2(300)
- BIC_LAT (Field4) — VARCHAR2(50)
- BIC_LNG (Field5) — VARCHAR2(50)
- BIC_NUM (Field6) — VARCHAR2(26)
BOARD (Untitled4)
- BOARD_SEQ (Key) — NUMBER(5,0) — Primary key — NOT NULL
- ID (Key2) — VARCHAR2(30) — Foreign key → MEMBER.ID — NOT NULL
- LOCATION (Field) — VARCHAR2(300)
- LIKES (Field2) — NUMBER(6,0)
- BOOKMARK (Field4) — NUMBER(6,0)
- INDATE (Field5) — Date
- HITS (Field6) — NUMBER(8,0)
- CAPTION (Field7) — VARCHAR2(1024)
- FILEPATH (Field8) — VARCHAR2(300)
BOOKMARK (Untitled5)
- BOARD_SEQ (Key2) — NUMBER(5,0) — Foreign key → BOARD.BOARD_SEQ — NOT NULL
- ID (Key22) — VARCHAR2(30) — Foreign key → BOARD.ID — NOT NULL
COMMENTS (CopyOfCopyOfUntitled5)
- CONTENTS (Field) — VARCHAR2(1024)
- BOARD_SEQ (Key3) — NUMBER(5,0) — Foreign key → BOARD.BOARD_SEQ — NOT NULL
- ID (Key22) — VARCHAR2(30) — Foreign key → BOARD.ID — NOT NULL
LIKES (CopyOfUntitled5)
- BOARD_SEQ (Key3) — NUMBER(5,0) — Foreign key → BOARD.BOARD_SEQ — NOT NULL
- ID (Key22) — VARCHAR2(30) — Foreign key → BOARD.ID — NOT NULL
MEMBER (CopyOfTable3)
- ID (Key) — VARCHAR2(30) — Primary key — NOT NULL
- PASSWORD (NAME) — VARCHAR2(10)
- NAME (ID) — VARCHAR2(50)
- EMAIL (Field5) — VARCHAR2(128)
- FILEPATH (Field3) — VARCHAR2(300)
- PHOTO_NAME (Field4) — VARCHAR2(40)
- INDATE (Field) — Date
MOUNT (Untitled3)
- MT_SEQ (Key) — NUMBER — Primary key — NOT NULL
- MT_NAME (Field) — VARCHAR2(128)
- MT_ADDR (Field2) — VARCHAR2(300)
- MT_TEL (Field3) — VARCHAR2(1024)
- MT_CITY (Field4) — VARCHAR2(128)
- MT_TOWN (Field5) — VARCHAR2(128)
- MT_LAT (Field6) — VARCHAR2(50)
- MT_LNG (Field7) — VARCHAR2(50)
- MT_DESC (Field8) — VARCHAR2(4000)
- MT_PARKING (Field9) — VARCHAR2(300)
- MT_BABY (Field10) — VARCHAR2(50)
- MT_PET (Field11) — VARCHAR2(50)
- MT_DETAIL (Field12) — VARCHAR2(4000)
PARK (Untitled)
- PK_SEQ (Key) — NUMBER — Primary key — NOT NULL
- PK_CITY (Field) — VARCHAR2(128)
- PK_NAME (Field2) — VARCHAR2(128)
- PK_KIND (Field3) — VARCHAR2(128)
- PK_ADDR (Field4) — VARCHAR2(500)
- PK_LAT (Field5) — VARCHAR2(50)
- PK_LNG (Field6) — VARCHAR2(50)
- PK_TEL (Field7) — VARCHAR2(26)
- ETC1 (Field8) — VARCHAR2(500)
- ETC2 (Field9) — VARCHAR2(500)
- ETC3 (Field10) — VARCHAR2(500)
- ETC4 (Field11) — VARCHAR2(500)
PU_WORKOUT_EQ (CopyOfUntitled2)
- WO_NAME (Key) — NUMBER — Primary key — NOT NULL
- WO_ADDR (Field) — VARCHAR2(300)
- WO_KIND (Field2) — VARCHAR2(1024)
- WO_CITY (Field3) — VARCHAR2(128)
- WO_TOWN (Field4) — VARCHAR2(128)
- WO_LAT (Field5) — VARCHAR2(50)
- WO_LNG (Field6) — VARCHAR2(50)
- WO_ADMIN (Field7) — VARCHAR2(300)
RIVER (CopyOfUntitled)
- R_SEQ (Key) — NUMBER — Primary key — NOT NULL
- R_NAME (Field) — VARCHAR2(128)
- R_ADDR (Field2) — VARCHAR2(300)
- R_TEL (Field3) — VARCHAR2(1024)
- R_CITY (Field4) — VARCHAR2(128)
- R_TOWN (Field5) — VARCHAR2(128)
- R_LAT (Field6) — VARCHAR2(50)
- R_LNG (Field7) — VARCHAR2(50)
- R_DESC (Field8) — VARCHAR2(4000)
- R_PARKING (Field9) — VARCHAR2(300)
- R_BABY (Field10) — VARCHAR2(50)
- R_PET (Field11) — VARCHAR2(50)
- R_DETAIL (Field12) — VARCHAR2(4000)