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