렛유인
테이블 (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