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