damoa
Tables (6)
Banner (배너)
- file (파일) — file
- sequence (순서) — number
- period (기간) — DateTime
- url (링크) — text
- banner_memo (메모) — text
Category (카테고리)
- unique_id (고유번호) — text — Primary key — NOT NULL
- category_type (카테고리) — CATEGORY_TYPE
- categoryInfo (카테고리 정보) — CategoryInfo — Foreign key → CategoryInfo.unique_id — NOT NULL
- user (유저) — User — Foreign key → User.email — NOT NULL
CategoryInfo (카테고리 정보)
- unique_id (고유번호) — text — Primary key — NOT NULL
- province_info (도) — PROVINCE_INFO
- city (시) — address
- applicate_at (신청날짜) — DateTime
- supporter (지원자) — user
- duty_date (모집기간) — DateTime
- support_item (지원품목) — SUPPORT_ITEM<list>
- category_image_list (카테고리 이미지) — image<list>
- youtube_address (유튜브주소) — text
- google_ads (구글광고) — google_ads
- region_logo (지역로고) — REGION_LOGO
- title (제목) — text
- money (지원금) — number
- progress_type (진행사항) — PROGRESS_TYPE
- keyword (키워드) — text
- content (내용) — text
- tag (태그) — Tag — Foreign key → Tag.unique_id — NOT NULL
City (도시)
- unique_id (고유번호) — text — Primary key — NOT NULL
- city_image (이미지) — image
- city_name (도시이름) — text
- province (도) — PROVINCE_INFO
Tag (태그)
- unique_id (고유번호) — text — Primary key — NOT NULL
- sequence (순서) — number
- tag (태그) — TAG_TYPE
- tag_name (태그이름) — text
User (유저)
- email (Key) — text — Primary key — NOT NULL
- phone (전화번호) — text
- user_type (유저타입) — enum
- ramdom_nickname (랜덤닉네임) — RAMDOM_NICKNAME
- rullet_count (룰렛카운트) — number
- event_boolean (이벤트여부) — boolean
- account_num (계좌번호) — number
- account_owner (계좌주) — text
- bank_type (은행명) — BANK_TYPE
- ramdom_image (랜덤이미지) — RAMDOM_IMAGE
- user_state (유저상태) — USER_STATE
- login_type (로그인타입) — LOGIN_TYPE