Showgle

Tables (7)

Events (Event)

  • id (no) — Primary key — NOT NULL
  • Key (team_no) — Foreign key → Untitled.Key — NOT NULL
  • name — 이벤트 이름
  • Field (sub_name)
  • description — 이벤스 설명 * 하위 목록들을 나누게 되면 추후 삭제 예정
  • create_date (created_date) — 게시글 생성날짜
  • modified_date — 게시글 수정 날짜
  • Field (category) — 대분류
  • Field (sub_category) — 소분류
  • Field (count) — 조회수
  • Field (delete) — 이벤트 삭제 여부
  • Field (profile) — 다운로드 할 프로필 (.pdf)
  • Field (image) — 다운로드할 이미지 파일 (.zip)
  • Field (video) — 웹 페이지에 보여질 비디오
  • Field (picture) — 웹페이지에 보여질 사진 자료
  • Field (hours) — 소요시간 (ex 10분 ~ 60분)
  • Field2 (member) — 편성인원 (ex. 7인 ~ 8인)
  • Field3 (region) — 활동지역
  • Field4 (tag) — # 태그
  • Field2 (team_introduction) — 팀 소개
  • Field2 (member_introduction) — 멤버 소개
  • Field2 (achievement) — 실적
  • Field2 (repertory) — 레퍼토리
  • Field2 (live_sketchy) — 라이브 스케치
  • Field2 (review) — 사용자 리뷰
  • Field (words)

Untitled (User)

  • Key (no) — Primary key — NOT NULL
  • Field (id)
  • Field (pw)
  • Field (name)
  • Field (phone)
  • Field (email)
  • Field2 (company)
  • Field (delete)

Untitled (Company)

  • Key (no) — Primary key — NOT NULL
  • Field (id)
  • Field (pw)
  • Field (name)
  • Field2 (phone)
  • Field3 (email)
  • Field4 (company)
  • Field5 (company_code)
  • Field (company_number)
  • Field (company_address)
  • Field (namecard)
  • Field (delete)

Untitled (Team)

  • Key (no) — Primary key — NOT NULL
  • Field (id)
  • Field (pw)
  • Field (name)
  • Field (phone)
  • Field2 (email)
  • Field (company)
  • Field3 (company_address)
  • Field (company_sort)
  • Field2 (company_code)
  • Field3 (bank_account)
  • Field (bank_account_owner)
  • Field (delete)

Untitled (Review)

  • Key (no) — Primary key — NOT NULL
  • id (event_no) — Foreign key → Events.id — NOT NULL
  • Key (user_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (comment)
  • Field (count)
  • Field (delete)

Untitled (Cart)

  • Key (no) — Primary key — NOT NULL
  • Key (user_no) — Foreign key → Untitled.Key — NOT NULL
  • id (event_no) — Foreign key → Events.id — NOT NULL
  • Field (delete)
  • Field (check)

Untitled (Estimation)

  • Key (no) — Primary key — NOT NULL
  • Key (user_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (event_name)
  • Field (event_date)
  • Field (event_time)
  • Field (event_region)
  • Field (region_detail)
  • Field2 (request)