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