newlyd
Tables (22)
application
- no — Bigint — Primary key — NOT NULL — index용, AutoIncrement
- dw_no — BigInt — Foreign key → dogwalker.no — NOT NULL
- avail_region — varchar(255) — 선택사항(시도, 시군구 입력)
- avail_day — varchar(2) — 선택사항(한글 한글자)
- certificate — int
- adopted — boolean — NOT NULL
- adopted_which — int — 1고양이 2강아지 3그외(중복가능)
- adopted_period — int — 개월 단위
- pet_type — int — NOT NULL — 1소중형 2대형 3초대형 4상관없음
- price — int — NOT NULL
- sentense — varcahr(255) — NOT NULL
- view — int — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
certificate
- no — Bigint — Primary key — NOT NULL — index용, AutoIncrement
- name — varchar(40) — NOT NULL
- info — varchar(255) — NOT NULL
- ap_no — Bigint — NOT NULL
comment
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- parent_no — BigInt — 대댓글이 참조하고 있는 댓글 번호
- depth — BigImt — NOT NULL — 댓글1 대댓글2
- context — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- rev_no — BigInt — NOT NULL
- cus_no — BigInt — 작성자는 고객 또는 도그워커
- dw_no — BigInt — 작성자는 고객 또는 도그워커
commision
- no — Bigint — Primary key — NOT NULL — index용, AutoIncrement
- cus_no — BigInt — Foreign key → customer.no — NOT NULL
- price — int — NOT NULL
- month — int — NOT NULL — 1이상 12이하
- day — int — NOT NULL — 1이상 31이하
- start_h — int — NOT NULL — 0이상 24이하
- start_m — int — NOT NULL — 0이상 59분이하
- end_h — int — NOT NULL — 0이상 24이하
- end_m — int — NOT NULL — 0이상 59분이하
- dog_name — varchar(30) — NOT NULL
- dog_age — int — NOT NULL — 개월 단위
- dog_weight — int — NOT NULL — kg 단위
- dog_type — varchar(30) — NOT NULL
- dog_aggr — int — NOT NULL — 1(매우약함)~5(매우강함)
- dog_health — int — NOT NULL — 1(매우안좋음)~5(매우좋음)
- road — varchar(255)
- view — int — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
cus_profileImage
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- cus_no — BigInt — Foreign key → customer.no — NOT NULL — 고객 번호
- dir_name — varchar(20) — NOT NULL — S3 객체 이름(일종의 폴더)
- file_name — varchar(255) — NOT NULL — .jpg
customer
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- email — varchar(255) — NOT NULL — id 역할, sns email도 여기
- pwd — varchar(255) — NOT NULL
- name — varchar(255)
- birth — int
- gen — char(1) — m / f
- phone — varchar(11) — 하이픈 없이 숫자만
- nick — varchar(255)
- addr — varchar(255)
- addr_detail — varchar(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- walk_cnt — int — NOT NULL
- acnt_type — varchar(10) — NOT NULL — 이메일"e" 구글"g" 네이버"n" 카카오"k"
customer_request
- no — Bigint — Primary key — NOT NULL — index용, AutoIncrement
- context — varchar(255) — NOT NULL
- com_no — Bigint — NOT NULL
diary
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- res_no — BigInt — Foreign key → reservation.no — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
dogwalker
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- email — varchar(40) — NOT NULL — id 역할, sns email도 여기
- pwd — varchar(40) — NOT NULL
- name — varchar(10)
- birth — int
- gen — char(1) — m / f
- phone — varchar(11) — 하이픈 없이 숫자만
- nick — varchar(20) — 20자 이내
- addr — varchar(255)
- addr_datail — varchar(255)
- applied — boolean — NOT NULL
- apply_passed — boolean — NOT NULL
- lec_passed — boolean — NOT NULL
- test_passed — boolean — NOT NULL
- inter_passed — boolean — NOT NULL
- passed — boolean — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- acnt_type — varchar(10) — NOT NULL — 이메일"e" 구글"g" 네이버"n" 카카오"k"
dw_profileImage
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- dw_no — BigInt — Foreign key → dogwalker.no — NOT NULL — 도그워커 번호
- dir_name — varchar(20) — NOT NULL — S3 객체 이름(일종의 폴더)
- file_name — varchar(255) — .jpg
faq
- no — int — Primary key — NOT NULL
- category — varchar(25) — NOT NULL
- question — varchar(255) — NOT NULL
- answer — varchar(255) — NOT NULL
inquiry
- no — Bigint — Primary key — NOT NULL — index용, AutoIncrement
- inquired_at — DATETIME — NOT NULL
- inquired_price — int — NOT NULL
- com_no — Bigint — NOT NULL
- ap_no — Bigint — NOT NULL
lecture
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- title — varchar(50) — NOT NULL
- video — varchar(255)
- dw_no — BigInt
- end_dt — DATETIME
mission
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- diary_no — BigInt — Foreign key → diary.no — NOT NULL
- res_no — BigInt — Foreign key → diary.res_no — NOT NULL
- essential — boolean — NOT NULL
- essen_type — int — 0방문 1산책전 2산책중 3산책완료
- cus_req_no — Bigint
- context — varchar(255) — NOT NULL
- dir_name — varchar(20) — NOT NULL — S3 객체 이름(일종의 폴더)
- file_name — varchar(255) — .jpg
offer
- no — Bigint — Primary key — NOT NULL — index용, AutoIncrement
- offered_at — DATETIME — NOT NULL
- offered_price — int — NOT NULL
- com_no — Bigint — NOT NULL — 의뢰인의 의뢰서
- ap_no — Bigint — NOT NULL
reservation
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- dt — DATETIME — NOT NULL
- canceled_dt — DATETIME
- status — int — NOT NULL — 0예약완료 1산책중 2산책완료 3결제완료
- inq_no — Bigint — 문의 또는 제안이 있을 수 있으므로 null
- offer_no — Bigint
- com_no — Bigint — NOT NULL — 거래 일방인 고객
- ap_no — Bigint — NOT NULL — 거래 일방인 도그워커
review
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- star — int — NOT NULL — 0이상 10이하
- context — TEXT — NOT NULL — 10자 이상
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- res_no — BigInt — NOT NULL
reviewImage
- no — int — Primary key — NOT NULL — index용, AutoIncrement
- dir_name — varchar(20) — NOT NULL
- file_name — varchar(255)
- Field — VARCHAR(255)
- rev_no — BigInt — NOT NULL
t_question
- no — int — Primary key — NOT NULL — index용, AutoIncrement
- test_no — BigInt — Foreign key → test.no — NOT NULL
- type — int — NOT NULL — 0객관식 1주관식
- question — varchar(255) — NOT NULL
- answer — varchar(255) — NOT NULL
- point — int — NOT NULL
- input — varchar(255)
temperture
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- tp — int — NOT NULL — 0이상 10이하
- diary_no — BigInt — NOT NULL
- res_no — BigInt — NOT NULL
test
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- start_dt — DATETIME — NOT NULL
- end_dt — DATETIME — NOT NULL
- dw_no — BigInt — NOT NULL
walk
- no — BigInt — Primary key — NOT NULL — index용, AutoIncrement
- res_no — BigInt — Foreign key → reservation.no — NOT NULL
- start_dt — DATETIME — NOT NULL
- end_dt — DATETIME — NOT NULL