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)