PARKINGMATE
Tables (14)
ASK (ask)
- IDX (idx) — INT — Primary key — NOT NULL
- ID (id) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- 문의유형 (type) — VARCHAR(50)
- 문의제목 (title) — VARCHAR(50)
- 문의내용 (content) — VARCHAR(1000)
- 사진업로드 (upload) — VARCHAR(200)
- 답글 (comment) — VARCHAR(200)
- 구분 (division) — INT
BOOKING (booking)
- 예약번호 (bookingnum) — INT — Primary key — NOT NULL
- 예약일자 (bookingdate) — DATETIME
- 예약차량번호 (bookingcarnum) — VARCHAR(300)
- 입차시간 (intime) — DATETIME
- 출차시간 (outime) — DATETIME
- 발렛유무 (valet) — INT
- 대행유무 (instand) — INT
- 예약금액 (price) — INT
- 예약상태구분 (status) — VARCHAR(100)
- 장애인여부 (obstacle) — INT
- 주차장고유번호 (idx) — INT — Foreign key → PARKINGLOT.주차장고유번호 — NOT NULL
- ID (id) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- 유저위도 (ulatitude) — DOUBLE
- 유저경도 (ulongitude) — DOUBLE
- 메이트위도 (pmlatitude) — DOUBLE
- 메이트경도 (pmlongitude) — DOUBLE
CAR TYPE (car_type)
- MODELNAME (modelname) — VARCHAR(300) — Primary key — NOT NULL
- BRANDNAME (brandname) — VARCHAR(100)
- LENGTH (length) — INT
- WIDTH (width) — INT
- HEIGHT (height) — INT
- WEIGHT (weight) — INT
COMMENT (comment)
- 댓글IDX (idx) — INT — Primary key — NOT NULL
- 커뮤니티IDX (idx2) — INT — Foreign key → COMMUNITY.커뮤니티IDX — NOT NULL
- ID (id2) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- 내용 (content) — VARCHAR(1000)
- REF (ref) — INT
- LEV (lev) — INT
- SUNBUN (sunbun) — INT
COMMUNITY (community)
- 커뮤니티IDX (idx) — INT — Primary key — NOT NULL
- ID (id2) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- 제목 (title) — VARCHAR(100)
- 내용 (content) — VARCHAR(1000)
- 작성날짜 (writedate) — DATETIME
- 조회수 (readnum) — INT
- 추천 (good) — INT
- 비추천 (bad) — INT
FAQ (faq)
- IDX (idx) — INT — Primary key — NOT NULL
- 질문 (question) — VARCHAR(100)
- 답변 (answer) — VARCHAR(1000)
MATE_PAYCHECK (mate_paycheck)
- IDX (idx) — INT — Primary key — NOT NULL
- 요청자ID (id) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- 시작일시 (starttime) — DATETIME
- 종료일시 (endtime) — DATETIME
- 상태구분 (status) — VARCHAR(200)
- 금액 (price) — INT
- 메이트ID (mid) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- CAR_NUM (car_num) — VARCHAR(300) — Foreign key → USER CARS.CAR_NUM — NOT NULL
NOTICE (notice)
- IDX (idx) — INT — Primary key — NOT NULL
- ID (id) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- 제목 (title) — VARCHAR(100)
- 내용 (content) — VARCHAR(1000)
- 작성날짜 (writedate) — DATETIME
- 조회수 (readnum) — INT
- 구분자 (division) — INT
NOTICE_POTO (notice_poto)
- IDX (idx) — INT — Primary key — NOT NULL
- IDX2 (notice_num) — INT — Foreign key → NOTICE.IDX — NOT NULL
- 첨부1 (poto_1) — VARCHAR(100)
- 첨부2 (poto_2) — VARCHAR(100)
- 첨부3 (poto_3) — VARCHAR(100)
- 첨부4 (poto_4) — VARCHAR(100)
PARKINGLOT (parkinglot)
- 주차장고유번호 (idx) — INT — Primary key — NOT NULL
- 주차장주소 (addr) — VARCHAR(200)
- 주차장유형 (type) — VARCHAR(100)
- 주차장최초금액 (price) — INT
- 주차장금액 (price2) — INT
- 주차운영시간 (time) — DATETIME
- 발렛유무 (valet) — INT
- 주차총 대수 (maxnum) — INT
- 장애인자리유무 (obstacle) — INT
- 제한높이 (maxheight) — INT
- 제한넓이 (maxwidth) — INT
- 제한중량 (maxweight) — INT
- 주차장이름 (name) — VARCHAR(200) — UNIQUE
- 주차장위도 (latitude) — DOUBLE
- 주차장경도 (longitude) — DOUBLE
PARKINGMATE (parkingmate)
- IDX (idx) — INT — Primary key — NOT NULL
- LICENSE (license) — VARCHAR(300)
- 운전경력 (history) — VARCHAR(300)
- 증명사진 (picture) — VARCHAR(300)
- 주소 (addr) — VARCHAR(300)
- 계좌 (account) — INT
- 은행 (bank) — VARCHAR(100)
- ID (id) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
REVIEW (review)
- ID (id) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- 예약번호 (bookingnum) — INT — Foreign key → BOOKING.예약번호 — NOT NULL
- 작성날짜 (writedate) — DATETIME
- 별점 (rating) — INT
- 내용 (content) — VARCHAR(1000)
- 사진업로드 (upload) — VARCHAR(500)
USER (user)
- ID (id) — VARCHAR(50) — Primary key — NOT NULL — USER ID
- PWD (pwd) — VARCHAR(100)
- NAME (name) — VARCHAR(100)
- 주민등록번호 (resident_num) — VARCHAR(200)
- 전화번호 (tel) — VARCHAR(100)
- 이메일 (email) — VARCHAR(100)
- 파킹메이트구분 (mate_use) — INT
- 포인트 (point) — INT
USER CARS (user_cars)
- CAR_NUM (car_num) — VARCHAR(300) — Primary key — NOT NULL
- MODELYEAR (model_year) — INT
- GASTYPE (gas_type) — VARCHAR(50)
- COLOR (color) — VARCHAR(50)
- GEAR (gear) — VARCHAR(50)
- ID (id2) — VARCHAR(50) — Foreign key → USER.ID — NOT NULL — USER ID
- MODELNAME (modelname) — VARCHAR(300) — Foreign key → CAR TYPE.MODELNAME — NOT NULL