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)