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 — 자격증첨부