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 — 수정일