Final

Tables (4)

CorMember

  • cor_rgn — NUMBER(20) — Primary key — NOT NULL
  • cor_form — VARCHAR2(40)
  • cor_name — VARCHAR2(60)
  • cor_boss — VARCHAR2(40)
  • cor_loc — VARCHAR2(100)

HrMember

  • hr_id — VARCHAR2(40) — Primary key — NOT NULL
  • hr_pw — VARCHAR2(40)
  • hr_name — VARCHAR2(40)
  • hr_email — VARCHAR2(100)
  • hr_phone — VARCHAR2(40)

IdvMember

  • member_id (id) — varchar2(40) — Primary key — NOT NULL
  • member_pw (pw) — varchar2(40)
  • member_name (name) — varchar2(40)
  • member_phone (phone) — vharchar2(40)

Scrap

  • Key — Primary key — NOT NULL
  • member_id (id) — varchar2(40) — Foreign key → IdvMember.member_id — NOT NULL