member

Tables (6)

1:1

  • member_ID — varchar(20) — Primary key — NOT NULL
  • inquiry_title — varchar(20)
  • inquiry_content — varchar(50)
  • write_time — DATETIME
  • answer — ENUM('true', 'false')

announcement

  • member_ID — varchar(20) — Primary key — NOT NULL
  • announcement_id — varchar(10)
  • write_time — DATETIME
  • content — varchar(500)
  • Field — VARCHAR(255)

delivery

  • member_ID — varchar(20) — Primary key — NOT NULL
  • car_number — varchar(10)
  • delivery_status — ENUM('운행 종료', '운행 중')

member

  • member_ID — varchar(20) — Primary key — NOT NULL
  • member_name — varchar(20)
  • member_password — varchar(50)
  • member_contact — varchar(20)
  • member_email — varchar(30)
  • member_address — varchar(50)
  • member_status — ENUM('승인대기', '활성', '탈퇴대기', '비활성')
  • createAt — DATETIME
  • lastLogin — DATETIME
  • member_type — ENUM('일반회원', '배송기사', '관리자')

user

  • member_ID — varchar(20) — Primary key — NOT NULL
  • business_name — varchar(20)
  • business_number — varchar(20)
  • business_address — varchar(30)
  • business_Certificate — BLOB

warehouse_manager

  • member_ID — varchar(20) — Primary key — NOT NULL
  • warehouse_ID — varchar(20)