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