렛유인

테이블 (20)

Class (Untitled)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Company (company)

  • Company ID (company_id) — int(5) — 기본 키 — NOT NULL
  • Company Name (company_name) — varchar(20) — NOT NULL
  • Company Detail (company_detail) — varchar(200)
  • Company Type ID (com_type_id) — int(5) — 외래 키 → CompanyType.Company Type ID — NOT NULL
  • Industry ID (industry_id) — int(5) — 외래 키 → Industry.Industry ID — NOT NULL

CompanyType (com_type)

  • Company Type ID (com_type_id) — int(5) — 기본 키 — NOT NULL
  • Company Type Name (com_type_name) — varchar(20) — NOT NULL
  • Company Type Detail (com_type_detail) — varchar(200)

Event (Untitled9)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Freepass (Untitled6)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Industry (industry)

  • Industry ID (industry_id) — int(5) — 기본 키 — NOT NULL
  • Industry Name (industry_name) — varchar(20) — NOT NULL
  • Industry Detail (industry_detail) — varchar(200)
  • Company ID (company_id) — int(5) — 외래 키 → Company.Company ID — NOT NULL

Interest (user_interest)

  • Interest ID (interest_id) — int(5) — 기본 키 — NOT NULL
  • Interest Name (interest_name) — varchar(20) — NOT NULL
  • Interest Detail (interest_detail) — varchar(200)

Join Path (path)

  • Path ID (path_id) — int(5) — 기본 키 — NOT NULL
  • Path Name (path_name) — varchar(20) — NOT NULL
  • Path Detail (path_detail) — varchar(200)

LTV (Untitled11)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Major (major)

  • Major ID (major_id) — int(5) — 기본 키 — NOT NULL
  • Major Name (major_name) — varchar(20) — NOT NULL
  • Major Detail (major_detail) — varchar(200)
  • University ID (univ_id) — int(5) — 외래 키 → University.University ID — NOT NULL

Major_Detail (Untitled3)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Offline Class (Untitled4)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Online Class (Untitled2)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Package (Untitled5)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

Product (Untitled7)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3

Publication (Untitled8)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

University (university)

  • University ID (univ_id) — int(5) — 기본 키 — NOT NULL
  • University Name (univ_name) — varchar(20) — NOT NULL
  • University Detail (univ_detail) — varchar(200)
  • Major ID (major_id) — int(5) — 외래 키 → Major.Major ID — NOT NULL

Urgent Inspection (Untitled10)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2

User (user)

  • User ID (user_id) — int(5) — 기본 키 — NOT NULL
  • ID (id) — varchar(20) — 기본 키 — NOT NULL
  • Mobile (mobile) — varchar(20) — 기본 키 — NOT NULL
  • Email (email) — varchar(100) — 기본 키 — NOT NULL
  • Name (name) — varchar(20) — NOT NULL
  • Gender (gender) — int(1) — NOT NULL
  • Password (password) — varchar(20) — NOT NULL
  • Birthday (birthday) — varchar(10) — NOT NULL
  • User Address (user_address) — varchar(100) — NOT NULL
  • Graduate Year (grad_year) — int(4) — NOT NULL
  • Marketing Agree (mkt_agree) — int(1) — NOT NULL
  • Path ID (path_id) — int(5) — 외래 키 → Join Path.Path ID — NOT NULL
  • Interest ID (interest_id) — int(5) — 외래 키 → Interest.Interest ID — NOT NULL
  • University ID (univ_id) — int(5) — 외래 키 → University.University ID — NOT NULL
  • Major ID (major_id) — int(5) — 외래 키 → Major.Major ID — NOT NULL
  • Zip Code (zip_code) — int(5) — 외래 키 → Zip Code.Zip Code — NOT NULL
  • Company ID (company_id) — int(5) — 외래 키 → Company.Company ID — NOT NULL
  • Nickname (nickname) — varchar(20)
  • Phone (phone) — varchar(20)

Zip Code (zip_code)

  • Zip Code (zip_code) — int(5) — 기본 키 — NOT NULL
  • Address (address) — varchar(100) — NOT NULL