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