Sample
Tables (3)
BusinessCard (business_card)
- Name Code (name_code) — BIGINT(11) — Primary key — NOT NULL
- Koean Name (korean_name) — VARCHAR(255)
- English Name (english_name) — VARCHAR(255)
- Cell Phone Number (cell_phone_number) — INT(174)
- Email (email) — VARCHAR(254)
- Work Code (work_code) — BIGINT(11) — Foreign key → WorkPlace.Work Code — NOT NULL
Department (department)
- Department Code (department_code) — BIGINT(11) — Primary key — NOT NULL
- Department Name (department_name) — VARCHAR(255)
WorkPlace (work_place)
- Work Code (work_code) — BIGINT(11) — Primary key — NOT NULL
- WorkPlace Name(Korean) (workplace _name(Korean)) — VARCHAR(255)
- WorkPlace Name(English) (workplace _name(English)) — VARCHAR(255)
- Position (position) — VARCHAR(100)
- Phone Number (phone_number) — INT(174)
- Fax (fax) — INT(174)
- Postal Code (postal_code) — INT(174)
- Address (address) — VARCHAR(256)
- Website (website) — VARCHAR(257)
- Department Code (department_code) — BIGINT(11) — Foreign key → Department.Department Code — NOT NULL