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)