ㄴㅇㅁㄴㅇ
Tables (13)
Board
- orderNo — int — Primary key — NOT NULL
- writer — varchar(110)
- title — varchar(255)
- subTitle — varchar(255)
- content — varchar(255)
- createDate — date
- modifiedDate — date
- price — int(11)
- distence — float
- GOODS — varchar(255)
- userId — VARCHAR(110) — NOT NULL
- images — VARCHAR(255)
Customer
- userId — VARCHAR(110) — Primary key — NOT NULL
Distance
- Key2 — VARCHAR(255) — Primary key — NOT NULL
- maxDIstance — float — NOT NULL
- Field — VARCHAR(255)
Leider
- riderId — VARCHAR2(110) — Primary key — NOT NULL
- mode — varchar(50)
- maxDistance — float
Order
- riderId — VARCHAR2(110) — Foreign key → Leider.riderId — NOT NULL
- orderNo — int — Foreign key → Board.orderNo — NOT NULL
- status — varchar(2) — NOT NULL
Reviews
- reiviewId — varchar(110) — Primary key — NOT NULL
- reiviewNo — int
- riderId — VARCHAR2(110) — NOT NULL
- orderNo — int — NOT NULL
Rider
- Key — VARCHAR(255) — Primary key — NOT NULL
- uerId — bigint(20) — NOT NULL
- vehicleType — VARCHAR(255)
Untitled
- memberId — int — Primary key — NOT NULL
- userId — VARCHAR(110) — NOT NULL
- riderId — VARCHAR2(110) — NOT NULL
- password — varchar(110) — NOT NULL
- name — varchar(20)
- nickName — varchar(110)
- birthDate — date
- gender — char(2)
- phone — varchar(11)
- address — varchar(220)
- createDate — date
- modifiedDate — date
- status — varchar(2)
Users
- uerId — bigint(20) — Primary key — NOT NULL
- userId(email) — varchar(110) — 유니크 속성
- password — bigint(20) — NOT NULL
- name — varchar(255) — NOT NULL
- nickname — varchar(100) — NOT NULL
- birth — varchar(11) — NOT NULL
- gender — varchar(100) — NOT NULL
- phonenumber — varchar(100) — NOT NULL — 고마운분, 귀한분, 더귀한분, 천생연분
- address — varchar(100) — NOT NULL
- createdate — varchar(255)
- role — varchar(10) — NOT NULL — 일반, 라이더, 관리자
- profileImage — varchar(200)
customer
- userId — VARCHAR(110) — Primary key — NOT NULL
member
- memberId — VARCHAR(110) — Primary key — NOT NULL
- riderId — VARCHAR(110) — NOT NULL
- password — VARCHAR(110) — NOT NULL
- name — VARCHAR(20)
- nickName — VARCHAR(110)
- birthDate — DATE
- gender — CHAR(2)
- phone — VARCHAR(11)
- address — VARCHAR(220)
- createDate — DATE
- status — VARCHAR(2)
- userId — VARCHAR(110) — NOT NULL