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)