카링
테이블 (12)
ATTACHEDFILE_ID
- ATTACHEDFILE_ID — number — 기본 키 — NOT NULL
- CARINFO_ID — NUMBER
- ORIGINAL_FILENAME — VARCHAR2(500 BYTE)
- SAVED_FILENAME — VARCHAR2(500 BYTE)
- FILE_SIZE — NUMBER
board
- board_id — number — 기본 키 — NOT NULL
- carInfo_id — number — 외래 키 → carInfo.carInfo_id — NOT NULL
- host_email — varchar2(20) — 외래 키 → host.host_email — NOT NULL
- title — varchar2(20)
- contents — varchar2(4000) — NOT NULL
- created_time — date
- price — number — NOT NULL
- area — varchar2(20) — NOT NULL
- rent_start
- rent_end — number
- LAT
- LNG
brand
- brand_id — number — 기본 키 — NOT NULL
- brand_name — varchar2(20)
carInfo
- carInfo_id — number — 기본 키 — NOT NULL
- car_year — number — NOT NULL
- seat — number — NOT NULL
- host_email (host_email2) — varchar2(20) — 외래 키 → host.host_email — NOT NULL
- fuel_id (Key) — number — 외래 키 → fuel.fuel_id — NOT NULL
- brand_id — number — 외래 키 → brand.brand_id — NOT NULL
- ATTACHEDFILE_ID — number — 외래 키 → ATTACHEDFILE_ID.ATTACHEDFILE_ID — NOT NULL
- carType_id (carType_id2) — number — 외래 키 → carType.carType_id — NOT NULL
- optionList_id — number — 외래 키 → optionList.optionList_id — NOT NULL
carType
- carType_id — number — 기본 키 — NOT NULL
- carType_name — varchar2(20)
feature
- feature_id (Key) — number — 기본 키 — NOT NULL
- feature_name — varchar2(40) — NOT NULL
fuel
- fuel_id (Key) — number — 기본 키 — NOT NULL
- fuel_name — varchar2(20) — NOT NULL
host
- host_email — varchar2(20) — 기본 키 — NOT NULL
- host_password — varchar2(20) — NOT NULL
- host_name — varchar2(20) — NOT NULL
- host_phone — varchar2(20) — NOT NULL
- host_img
optionList
- optionList_id — number — 기본 키 — NOT NULL
- carInfo_id — number
- option_value — varchar2(100)
- feature_id (Key) — number — 외래 키 → feature.feature_id — NOT NULL
reservation
- reservation_id — number — 기본 키 — NOT NULL
- board_id — number — 외래 키 → board.board_id — NOT NULL
- carInfo_id (carInfo_id2) — number — 외래 키 → board.carInfo_id — NOT NULL
- host_email — varchar2(20) — 외래 키 → board.host_email — NOT NULL
- reservation_date — date — NOT NULL
- total_price — number — NOT NULL
- rent_start — number — NOT NULL
- rent_end — number — NOT NULL
- status — varchar2(20)
- customer_email (customer_email2) — varchar2(20) — 외래 키 → user.customer_email — NOT NULL
review
- review_id — number — 기본 키 — NOT NULL
- created_time — date
- rate — number — NOT NULL
- contents — varchar2(4000) — NOT NULL
- reservation_id (reservation_id2) — number — 외래 키 → reservation.reservation_id — NOT NULL
- carInfo_id — number — 외래 키 — NOT NULL
- board_id — number — 외래 키 → reservation.board_id — NOT NULL
- carInfo_id (carInfo_id2) — number — 외래 키 → reservation.carInfo_id — NOT NULL
- host_email — varchar2(20) — 외래 키 → reservation.host_email — NOT NULL
user
- customer_email — varchar2(20) — 기본 키 — NOT NULL
- customer_password — varchar2(20) — NOT NULL
- customer_name — varchar2(20) — NOT NULL
- customer_address — varchar2(200) — NOT NULL
- customer_phone — varchar2(20) — NOT NULL
- license — varchar2(20) — NOT NULL
- CUSTOMER_IMG — VARCHAR2(100 BYTE)