TK

Analysis & feasibility study for conference & translation management service.

테이블 (21)

administrator (이벤트 관리자 계정) (Untitled3)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • event_id (BIGINT) — BIGINT — 외래 키 → event (수출상담행사).ID — NOT NULL — primary key
  • ID (Key2) — BIGINT — 외래 키 — NOT NULL — primary key
  • username (Field) — VARCHAR(25) — NOT NULL — the administrator username
  • password (Field2) — VARCHAR(100) — NOT NULL — the administrator password
  • type (Field3) — INTEGER — NOT NULL — the administrator type ( 0 is administrator, 1 is translation company, 2 is hotel )
  • name (Field4) — VARCHAR(100) — NOT NULL — the name of the entity (such as company name, etc.)
  • email (Field5) — VARCHAR(100) — NOT NULL — the contact E-mail of this administrator

buyer (바이어) (Untitled4)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • event_id (BIGINT) — BIGINT — 외래 키 → event (수출상담행사).ID — NOT NULL — primary key of the event
  • name (Field) — VARCHAR(100) — NOT NULL — the name of the company
  • approved (Field2) — BOOLEAN — NOT NULL — whether this company has been approved
  • corporate_id (Field3) — VARCHAR(100) — the company's ID
  • confirmed (Field4) — BOOLEAN — NOT NULL — whether this company's participation has been confirmed
  • booth_no (Field5) — INTEGER — NOT NULL — this company's booth number
  • trade_office (Field6) — VARCHAR(50) — NOT NULL — the trade office that this company belongs to
  • capabilities (Field7) — VARCHAR(50) — the classification of this company's capabilities (may be null)
  • pic_name (Field8) — VARCHAR(100) — NOT NULL — the name of this company's person-in-charge
  • pic_name_eng (Field9) — VARCHAR(100) — NOT NULL — the name of this company's person-in-charge, in roman alphabets
  • pic_phone_no (Field10) — VARCHAR(100) — NOT NULL — the phone number of this company's person-in-charge
  • pic_mobile_no (Field11) — VARCHAR(100) — NOT NULL — the mobile phone number of this company's PIC
  • pic_email (Field12) — VARCHAR(100) — NOT NULL — the email address of this company's PIC
  • consent (Field13) — BOOLEAN — NOT NULL — whether this company's PIC agreed with the terms and conditions
  • on_site (Field14) — BOOLEAN — NOT NULL — whether this company will be on site
  • Field15

buyer_accomodation_info (바이어 숙박 정보) (Untitled18)

  • id (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • buyer_id (BIGINT) — BIGINT — 외래 키 → buyer (바이어).event_id — NOT NULL — primary key of the buyer
  • place_of_stay (Field) — VARCHAR(100) — NOT NULL — where the buyer will stay (name of hotel, etc.)
  • checkin_date (Field2) — DATETIME — NOT NULL — when the buyer will check in
  • checkout_date (Field3) — DATETIME — NOT NULL — when the buyer will checkout
  • room_type (Field4) — VARCHAR(50) — NOT NULL — the type of the room
  • room_no (Field5) — VARCHAR(50) — NOT NULL — the number of the room
  • dining_info (Field6) — VARCHAR(100) — NOT NULL — the buyer's dining preferences (such as breakfast)
  • customer_name (Field7) — VARCHAR(100) — the name of the customer (usually, PIC)
  • customer_title (Field8) — VARCHAR(100) — the job title of the customer (usually, PIC)
  • companion (Field9) — VARCHAR(100) — person who will be with the customer

buyer_account (바이어측 계정 정보. 대표계정 한개는 반드시 필요) (CopyOfUntitled17)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • buyer_id (Key2) — BIGINT — 외래 키 → buyer (바이어).ID — NOT NULL — primary key of the buyer
  • subscriber_id (BIGINT) — BIGINT — 외래 키 → subscriber (수출상담행사 웹사이트 가입 회원. 단순 관심회원/바이어회원/셀러회원 可).event_id — NOT NULL — primary key of the subscriber
  • is_representative (Field) — BOOLEAN — NOT NULL — whether this account is a representative of this company

buyer_category (Untitled8)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • buyer_id (BIGINT) — BIGINT — 외래 키 → buyer (바이어).event_id — NOT NULL — primary key of the buyer (this is a mapping table)
  • category_id (Key2) — BIGINT — 외래 키 → category (제품/서비스 분야).ID — NOT NULL — primary key of the category (this is a mapping table)
  • ID (Key22) — BIGINT — 외래 키 → category (제품/서비스 분야).ID — NOT NULL — primary key

buyer_resource_file (바이어가 업로드한 파일) (CopyOfUntitled10)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • buyer_id (BIGINT) — BIGINT — 외래 키 → buyer (바이어).event_id — NOT NULL — primary key of the buyer who uploaded this file
  • link (Field) — VARCHAR(300) — NOT NULL — the URL of the file
  • name (Field2) — VARCHAR(300) — NOT NULL — the name of the file
  • description (Field3) — VARCHAR(300) — NOT NULL — the description of the file

buyer_to_invite (초청할 바이어 정보) (Untitled11)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • seller_id (BIGINT) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).event_id — NOT NULL — primary key of the seller who wishes to invite this buyer
  • ID (Key2) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).ID — NOT NULL — primary key
  • buyer_name (Field) — VARCHAR(100) — NOT NULL — the name of the buyer
  • buyer_pic_name (Field2) — VARCHAR(100) — NOT NULL — the name of the buyer's person-in-charge
  • buyer_country (Field3) — VARCHAR(100) — NOT NULL — the country where the buyer is from
  • buyer_city (Field4) — VARCHAR(100) — NOT NULL — the city where the buyer is from
  • buyer_phone_no (Field5) — VARCHAR(100) — NOT NULL — the buyer's phone number
  • buyer_email (Field6) — VARCHAR(100) — NOT NULL — the buyer's e-mail address
  • reason (Field7) — VARCHAR(300) — NOT NULL — the reason why the seller wishes to invite the buyer

buyer_trasportation_info (바이어 교통수단 정보 (항공편 등) (Untitled16)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • buyer_id (BIGINT) — BIGINT — 외래 키 → buyer (바이어).event_id — NOT NULL — primary key of the buyer
  • arrival_date (Field) — DATETIME — NOT NULL — the date this buyer is scheduled to arrive
  • departure_date (Field2) — DATETIME — NOT NULL — the date this buyer is scheduled to leave
  • entry_point (Field3) — VARCHAR(100) — NOT NULL — where this buyer is scheduled to arrive at
  • departure_point (Field4) — VARCHAR(100) — NOT NULL — where this buyer is scheduled to leave through
  • arrived (Field5) — BOOLEAN — NOT NULL — whether this buyer has arrived
  • departed (Field6) — BOOLEAN — NOT NULL — whether this buyer has departed
  • trans_id (Field7) — VARCHAR(100) — NOT NULL — the identifier of the transportation method (such as flight no, etc.)

category (제품/서비스 분야) (Untitled6)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • ID (BIGINT) — BIGINT — 외래 키 → event (수출상담행사).ID — NOT NULL — primary key of the event
  • ID (Key2) — BIGINT — 외래 키 — NOT NULL — primary key
  • name (Field) — VARCHAR(100) — NOT NULL — the category (or characteristic) of the company
  • description (Field2) — VARCHAR(300) — a brief description of this category. can be blank (or null)

event (수출상담행사) (Untitled)

  • ID (BIGINT) — BIGINT — 기본 키 — NOT NULL — primary key
  • event_name (Field) — VARCHAR(100) — NOT NULL — the name of this event
  • event_date (Field2) — DATETIME — NOT NULL — the date when this event will be held (auto-generated)
  • stay_info_service_used (Field3) — BOOLEAN — NOT NULL — whether this event uses the stay information service
  • on_site_arrangement_used (Field4) — BOOLEAN — NOT NULL — whether this event uses the on-site arrangement service
  • trade_office_used (Field5) — BOOLEAN — NOT NULL — whether this event uses the trade office service
  • sideline_service_used (Field6) — BOOLEAN — NOT NULL — whether this event uses the sideline event support service

interpretation_info (바이어 통역 정보) // SELECT * FROM interpretation_info INNER JOIN buyer WHERE buyer.event_id = event.id (Untitled14)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • buyer_id (BIGINT) — BIGINT — 외래 키 → buyer (바이어).event_id — NOT NULL — primary key of the buyer that needs interpretation
  • language_id (Key2) — BIGINT — 외래 키 → languages (행사에서 사용되는 언어 목록).ID — NOT NULL — primary key of the language that needs to be interpreted
  • ID (Key22) — BIGINT — 외래 키 → languages (행사에서 사용되는 언어 목록).ID — NOT NULL — primary key
  • interpretation_provider (Field) — VARCHAR(50) — NOT NULL — the name of interpretation provider
  • interpreter_name (Field2) — VARCHAR(100) — NOT NULL — the name of the interpreter
  • interpreter_contact (Field3) — VARCHAR(100) — NOT NULL — the phone number of the interpreter

language_needed_for_session (상담세션에 필요한 언어 목록)) (Untitled15)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • meeting_session_id (Key2) — BIGINT — 외래 키 → meeting_session (상담 세션).ID — NOT NULL — primary key
  • language_id (Key3) — BIGINT — 외래 키 → languages (행사에서 사용되는 언어 목록).ID — NOT NULL — primary key
  • ID (Key22) — BIGINT — 외래 키 → languages (행사에서 사용되는 언어 목록).ID — NOT NULL — primary key
  • ID (BIGINT3) — BIGINT — 외래 키 → meeting_session (상담 세션).event_id — NOT NULL — primary key

languages (행사에서 사용되는 언어 목록) (Untitled13)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • event_id (BIGINT) — BIGINT — 외래 키 → event (수출상담행사).ID — NOT NULL — primary key of the event
  • ID (Key2) — BIGINT — 외래 키 — NOT NULL — primary key
  • name (Field) — VARCHAR(50) — NOT NULL — the name of the language (in this language)
  • name_eng (Field2) — VARCHAR(50) — NOT NULL — the name of the language (in English)
  • comments (Field3) — VARCHAR(300) — any special comments (such as precautions, etc.)

meeting_session (상담 세션) (Untitled12)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • seller_id (BIGINT) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).event_id — NOT NULL — primary key of the seller
  • buyer_id (BIGINT2) — BIGINT — 외래 키 → buyer (바이어).event_id — NOT NULL — primary key of the buyer
  • event_id (BIGINT3) — BIGINT — 외래 키 → event (수출상담행사).ID — NOT NULL — primary key of the event
  • session_name (Field) — VARCHAR(100) — NOT NULL — the name of the session
  • start_time (Field2) — DATETIME — NOT NULL — when this seesion starts
  • end_time (Field3) — DATETIME — NOT NULL — when this session ends

meeting_session_record (상담일지) (Untitled19)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • meeting_session_id (Key2) — BIGINT — 외래 키 → meeting_session (상담 세션).ID — NOT NULL — primary key of the meeting session
  • subject (Field) — VARCHAR(100) — NOT NULL — the subject of this record
  • content (Field2) — BIGTEXT — NOT NULL — the contents of this record
  • timestamp (Field3) — DATETIME — NOT NULL — the time when this record was saved (auto-generated)

seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급) (Untitled5)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary kjey
  • event_id (BIGINT) — BIGINT — 외래 키 → event (수출상담행사).ID — NOT NULL — primary key of the event
  • ID (Key2) — BIGINT — 외래 키 — NOT NULL — primary key
  • is_approved (Field2) — BOOLEAN — NOT NULL — whether this company has been approved
  • confirmed (Field7) — BOOLEAN — NOT NULL — whether this company's participation has been confirmed
  • corporate_id (Field3) — VARCHAR(50) — NOT NULL — the company's ID
  • booth_no (Field4) — INTEGER — the company's booth number (may be null)
  • on_site (Field5) — BOOLEAN — NOT NULL — whether this company will be on site or online
  • is_participating (Field6) — INTEGER — NOT NULL — 1 is yes, -1 is no, 0 is TBD
  • name (Field) — VARCHAR(200) — NOT NULL — the name of the company
  • name_eng (Field8) — VARCHAR(200) — NOT NULL — the name of the company (in roman alphabets)
  • business_no (Field9) — VARCHAR(200) — NOT NULL — the business reginstration number of this company
  • website (Field10) — VARCHAR(300) — the website of this company
  • address (Field11) — VARCHAR(300) — NOT NULL — the address of this company
  • pic_name (Field12) — VARCHAR(100) — NOT NULL — the name of the person-in-charge
  • pic_name_eng (Field13) — VARCHAR(100) — NOT NULL — the name of the person-in-charge, in roman alphabets
  • pic_title (Field14) — VARCHAR(100) — NOT NULL — the job title of the person-in-charge
  • pic_title_eng (Field15) — VARCHAR(100) — NOT NULL — the job title of the person-in-charge, in roman alphabets
  • pic_phone_no (Field16) — VARCHAR(100) — NOT NULL — the phone number of the company's person-in-charge
  • pic_mobile_no (Field17) — VARCHAR(100) — NOT NULL — the mobile phone number of the company's person-in-charge
  • pic_email (Field18) — VARCHAR(100 — NOT NULL — the e-mail address of the company's person-in-charge

seller_account (셀러측 계정 정보. 셀러측 대표계정 한개는 반드시 필요) (Untitled17)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • seller_id (Key2) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).ID — NOT NULL — primary kjey of the seller
  • subscriber_id (Key3) — BIGINT — 외래 키 → subscriber (수출상담행사 웹사이트 가입 회원. 단순 관심회원/바이어회원/셀러회원 可).ID — NOT NULL — primary key of the subscriber
  • ID (Key22) — BIGINT — 외래 키 → subscriber (수출상담행사 웹사이트 가입 회원. 단순 관심회원/바이어회원/셀러회원 可).ID — NOT NULL — primary key
  • is_representative (Field) — BOOLEAN — NOT NULL — whether this account is a representative of this company

seller_category (Untitled7)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • category_id (BIGINT2) — BIGINT — 외래 키 → category (제품/서비스 분야).ID — NOT NULL — primary key of the category (this is a mapping table)
  • seller_id (BIGINT) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).event_id — NOT NULL — primary key of the seller (this is a mapping table)
  • Key (Key2) — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).ID — NOT NULL
  • ID (Key22) — BIGINT — 외래 키 → category (제품/서비스 분야).ID — NOT NULL — primary key

seller_resource_file (셀러가 업로드한 파일) (Untitled10)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • seller_id (BIGINT) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).event_id — NOT NULL — primary key of the seller this file belongs to
  • Key (Key2) — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).ID — NOT NULL
  • ID (Key22) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).ID — NOT NULL — primary key
  • link (Field) — VARCHAR(300) — NOT NULL — the URL of the file
  • name (Field2) — VARCHAR(300) — NOT NULL — the name of the file
  • description (Field3) — VARCHAR(300) — NOT NULL — the description of the file

seller_service (셀러가 제공하는 제품, 서비스) (Untitled9)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • seller_id (BIGINT) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).event_id — NOT NULL — primary key of the seller
  • ID (Key2) — BIGINT — 외래 키 → seller (셀러 정보이며, 사이트에서는 '국내기업'으로 언급).ID — NOT NULL — primary key
  • name (Field) — VARCHAR(300) — NOT NULL — the name of the service
  • name_eng (Field2) — VARCHAR(300) — NOT NULL — the name of the service (roman alphabets)
  • description (Field3) — BIGTEXT — NOT NULL — the description of the service
  • description_eng (Field4) — BIGTEXT — NOT NULL — the description of the service

subscriber (수출상담행사 웹사이트 가입 회원. 단순 관심회원/바이어회원/셀러회원 可) (Untitled2)

  • ID (Key) — BIGINT — 기본 키 — NOT NULL — primary key
  • event_id (BIGINT) — BIGINT — 외래 키 → event (수출상담행사).ID — NOT NULL — primary key of the event
  • ID (Key2) — BIGINT — 외래 키 — NOT NULL — primary key
  • username (Field2) — VARCHAR(25) — NOT NULL — the user's login id
  • password (Field8) — VARCHAR(100) — NOT NULL — the user's password (bcrypt-encrypted)
  • name (Field) — VARCHAR(50) — the user's name (or company name)
  • name_eng (Field3) — VARCHAR(50) — the user's name (in roman alphabet)
  • company_name (Field4) — VARCHAR(50) — the user's company name
  • phone_no (Field5) — VARCHAR(50) — the user's phone number
  • mobile_no (Field6) — VARCHAR(50) — the user's mobile phone number
  • email (Field7) — VARCHAR(100) — NOT NULL — the user's E-mail address
  • is_participating (Field9) — BOOLEAN — NOT NULL — default is true, whether this user is participating
  • join_date (Field10) — DATETIME — NOT NULL — auto-generated