CoRunning

Tables (8)

CREW_APPLICATION

  • ID — NUMBER(19,0) — Primary key
  • APPLICANT_ID — VARCHAR2(255 CHAR)
  • APPLICANT_NAME — VARCHAR2(255 CHAR)
  • APPLIED_AT — TIMESTAMP
  • BIRTH_DATE — VARCHAR2(255 CHAR)
  • HIRE_DATE — VARCHAR2(255 CHAR)
  • PHONE — VARCHAR2(255 CHAR)
  • USER_ADDRESS — VARCHAR2(255 CHAR)
  • CREW_BOARD_ID — NUMBER(19,0) — Foreign key → CREW_BOARD.ID
  • ID (ID2) — NUMBER(19,0) — Foreign key → CREW_BOARD.ID

CREW_BOARD

  • ID — NUMBER(19,0) — Primary key
  • BOARD_TYPE — VARCHAR2(255 CHAR)
  • CONTENT — VARCHAR2(2000 CHAR)
  • CREATED_AT — TIMESTAMP
  • CURRENT_COUNT — NUMBER(10,0)
  • DEADLINE — DATE
  • RECRUIT_COUNT — NUMBER(10,0)
  • REGION — VARCHAR2(255 CHAR)
  • ROUTE_PATH_JSON — CLOB
  • RUN_AT — VARCHAR2(255 CHAR)
  • TITLE — VARCHAR2(255 CHAR)
  • WRITER_ID — VARCHAR2(255 CHAR)
  • WRITER_NAME — VARCHAR2(255 CHAR)
  • USER_ID — VARCHAR2(255 CHAR) — Foreign key → USERS.USER_ID

CREW_COMMENT

  • ID — NUMBER(19,0) — Primary key
  • CONTENT — VARCHAR2(1000 CHAR)
  • CREATED_AT — TIMESTAMP
  • WRITER_ID — VARCHAR2(255 CHAR)
  • WRITER_NAME — VARCHAR2(255 CHAR)
  • BOARD_ID — NUMBER(19,0) — Foreign key → CREW_BOARD.ID
  • ID (ID2) — NUMBER(19,0) — Foreign key → CREW_BOARD.ID

ROUTE

  • ROUTE_ID — NUMBER(19,0) — Primary key
  • CREATED_AT — TIMESTAMP
  • DESCRIPTION — CLOB
  • DIFFICULTY — VARCHAR2(255 CHAR)
  • DISTANCE — BINARY_DOUBLE
  • LIKED — NUMBER
  • LOCATION — VARCHAR2(255 CHAR)
  • ROUTE — CLOB
  • TITLE — VARCHAR2(255 CHAR)
  • TYPE — VARCHAR2(255 CHAR)
  • WRITER — VARCHAR2(255 CHAR)
  • WRITER_NAME — VARCHAR2(255 CHAR)
  • USER_ID — VARCHAR2(255 CHAR) — Foreign key → USERS.USER_ID

ROUTE_COMMENT

  • ID — NUMBER(19,0) — Primary key
  • CONTENT — VARCHAR2(1000 CHAR)
  • CREATED_AT — TIMESTAMP
  • WRITER_ID — VARCHAR2(255 CHAR)
  • WRITER_NAME — VARCHAR2(255 CHAR)
  • ROUTE_ID (ROUTE_ID2) — NUMBER(19,0) — Foreign key → ROUTE.ROUTE_ID

ROUTE_DIP

  • ID — NUMBER(19,0) — Primary key
  • COMPLETE — NUMBER(10,0)
  • DISTANCE — BINARY_DOUBLE
  • LOCATION — VARCHAR2(255 CHAR)
  • RECORD — VARCHAR2(255 CHAR)
  • TITLE — VARCHAR2(255 CHAR)
  • USER_ID — VARCHAR2(255 CHAR)
  • ROUTE_ID (ROUTE_ID2) — NUMBER(19,0) — Foreign key → ROUTE.ROUTE_ID

ROUTE_LIKE

  • ID — NUMBER(19,0) — Primary key
  • USER_ID — VARCHAR2(255 CHAR)
  • ROUTE_ID (ROUTE_ID2) — NUMBER(19,0) — Foreign key → ROUTE.ROUTE_ID

USERS

  • USER_ID — VARCHAR2(255 CHAR) — Primary key
  • BIRTH_DATE — VARCHAR2(255 CHAR)
  • HIRE_DATE — VARCHAR2(255 CHAR)
  • PHONE — VARCHAR2(255 CHAR)
  • USER_ADDRESS — VARCHAR2(255 CHAR)
  • USER_NAME — VARCHAR2(255 CHAR)
  • USER_PW — VARCHAR2(255 CHAR)