petshop
Tables (6)
123
- PK (id) — varchar — Primary key — NOT NULL
- FK (seq) — number
- Field
Untitled (admin)
- id (ID) — varchar2(20) — Foreign key → member.id — NOT NULL — 아이디입니다
- Field
member
- id (ID) — varchar2(20) — Primary key — NOT NULL — 아이디입니다
- Field (password) — varchar2(20) — NOT NULL
- Field2 (email) — varchar2(40) — NOT NULL
- Field3 (phone) — varchar2(20) — NOT NULL
- Field4 (name) — varchar2(20) — NOT NULL
- Field5 (address) — varchar2(100) — NOT NULL
- Field (role) — enum — NOT NULL — 1,2,3,4로 권한 설정
order
- Key (oseq) — varchar(20) — Primary key — NOT NULL
- id (ID) — varchar2(20) — Foreign key → member.id — NOT NULL — 아이디입니다
sitter&trainer
- 아이디 (id) — PK — Primary key — NOT NULL
- 암호 (password) — NN
- 이름 (name) — NN
- 전화번호 (phone) — NN
- 이메일 (email)
- 프로필사진 (profileimage)
- 자기소개 (introduce)
sitter&trainer (sitter&trainer_roles)
- id (ID) — varchar2(20) — Foreign key → member.id — NOT NULL — 아이디입니다
- Field (role) — role — NOT NULL — 권한부여 입니다
- Field (profiletitle) — varchar2(20) — NOT NULL — 프로필제목입니다.
- Field (introduce) — varchar2 — NOT NULL
- Field (license) — varchar2 — NOT NULL — 자격증첨부