delivery_app
Tables (3)
Untitled (member)
- Key (member_no) — bigint — Primary key — NOT NULL — id
- Field (member_email) — varchar(100) — NOT NULL — 아이디
- Field (member_pwd) — varchar(200) — NOT NULL — 비밀번호
- Field (member_name) — varchar(50) — NOT NULL — 회원이름
- Field (member_signup_date) — timestamp — NOT NULL — 가입일
- Field (created_dt) — timestamp — NOT NULL — 생성일
- Field (modified_dt) — timestamp — NOT NULL — 수정일
Untitled (delivery)
- Key (delivery_no) — bigint — Primary key — NOT NULL — 배달id
- Key (member_no) — bigint — Foreign key → Untitled.Key — NOT NULL — 회원id
- Key (rider_no) — bigint — Foreign key → Untitled.Key — NOT NULL — 라이더id
- Field (address) — varchar(100) — NOT NULL — 배달주소
- Field2 (delivery_platform) — varchar(10) — NOT NULL — 주문 채널
- Field4 (delivery_status) — varchar(10) — NOT NULL — 배달상태
- Field5 (delivery_dt) — timestamp — NOT NULL — 배달일자
- Field (order_no) — bigint — NOT NULL — 주문번호
Untitled (rider)
- Key (rider_no) — bigint — Primary key — NOT NULL — 라이더id
- Field (rider_id) — varchar(10) — 라이더 아이디
- Field (rider_pwd) — varchar(200) — 라이더 비밀번호
- Field (rider_name) — varchar(50) — 라이더 이름
- Field (rider_signup_date) — timestamp — 가입일
- Field (created_dt) — timestamp — 생성일
- Field (modified_dt) — timestamp — 수정일