B-TIME

Tables (28)

ERRANDS_FORM (심부름 신청서)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — STRING
  • startDate (Field2) — DATE
  • time (Field3) — STRING
  • latitude (Field4) — FLOAT
  • longitude (Field5) — FLOAT
  • zip (Field6) — STRING
  • whatDo (Field16) — BOOLEAN
  • isOnline (Field8) — BOOLEAN
  • isOff (Field13) — BOOLEAN
  • content (Field9) — TEXT
  • images (Field14) — JSON
  • price (Field10) — INTEGER
  • isclbrt (Field15) — BOOLEAN
  • clbrtcount (Field18) — INTEGER
  • current_count (Field20) — INTEGER
  • createdAt (Field11) — DATE
  • updatedAt (Field12) — DATE
  • er_state (Field17) — STRING
  • e_state (Field7) — STRING
  • timer (Field19) — DATE
  • endDate (Field21) — DATE
  • e_price (Field22) — INTEGER
  • cancel_info (Field23) — STRING
  • cancel_date (Field24) — DATE

ERRANDS_ORDER (요청사항 리스트)

  • id (Key2) — INTEGER — Primary key — NOT NULL
  • ERRANDS_FORMID (Key) — INTEGER — Foreign key → ERRANDS_FORM.id — NOT NULL
  • title (Field) — TEXT
  • isCheck (Field2) — BOOLEAN
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

ERRANDS_WORK (입찰자 리스트)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • ERRANDS_FORMID (Key3) — INTEGER — Foreign key → ERRANDS_FORM.id — NOT NULL
  • price (Field) — INTEGER
  • title (Field8) — STRING
  • content (Field4) — TEXT
  • isCheck (Field5) — BOOLEAN
  • isCancelTxt (Field7) — TEXT
  • er_state (Field6) — TEXT
  • e_state (Field11) — TEXT
  • isCash (Field10) — BOOLEAN
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

EVENT (이벤트 (배너))

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — STRING
  • order (Field2) — INTEGER
  • open (Field3) — BOOLEAN
  • content (Field4) — TEXT
  • images (Field5) — STRING
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE

FAQ (자주묻는질문)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — TEXT
  • content (Field2) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

HELP_FORM (헬피 신청서)

  • Key2 — INTEGER — Primary key — NOT NULL
  • userid (Key) — INTEGER — Foreign key → USER.id — NOT NULL
  • access (Field) — BOOLEAN
  • id_photo (Field2) — STRING
  • face_photo (Field3) — STRING

INQUIRY (문의)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • content (Field) — TEXT
  • iswhthr (Field2) — BOOLEAN
  • images (Field3) — JSON
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

INQUIRY_ECNER (문의답변)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • inquiryikd (Key22) — INTEGER — Foreign key → INQUIRY.userid — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • content (Field) — TEXT
  • images (Field2) — JSON
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

NC_PATTE (닉네임 패턴)

  • id (Key) — Primary key — NOT NULL
  • nickname (Field)

NOTICE (공지사항)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — STRING
  • order (Field2) — INTEGER
  • open (Field3) — BOOLEAN
  • content (Field5) — TEXT
  • createdAt (Field4) — DATE
  • updatedAt (Field6) — DATE

POLICY (약관 및 정책)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — STRING
  • content (Field2) — TEXT
  • order (Field5) — INTEGER
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

PROFILE_CRTFC (자격증)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • crd (Field) — STRING
  • issuer (Field2) — STRING
  • issueDate (Field5) — DATE
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

Page (수수료율 등의 기초정보)

  • id (Key2) — Primary key — NOT NULL
  • outcount (Field) — INTEGER
  • inputcount (Field2) — INTEGER
  • addspoint (Field3) — INTEGER
  • tradecount (Key) — INTEGER — NOT NULL

ROOM (채팅[룸])

  • id (Key) — Primary key — NOT NULL
  • userid (Key22) — INTEGER — Foreign key → ERRANDS_FORM.userid — NOT NULL
  • lastMessasge (Field) — STRING
  • active (Field2) — STRING
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE
  • targetid (Key2) — INTEGER — Foreign key → ERRANDS_FORM.id — NOT NULL
  • senderid (Key23) — INTEGER — Foreign key → ERRANDS_FORM.userid — NOT NULL
  • type (Field5) — STRING

USER (회원)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • email (Field) — STRING
  • salt (Field2) — STRING
  • password (Field3) — STRING
  • nickname (Field5) — STRING
  • name (Field10) — STRING
  • avatar (Field20) — TEXT
  • tel (Field9) — STRING
  • gender (Field11) — STRING
  • star (Field21) — FLOAT
  • point (Field8) — INTEGER
  • jobcount (Field25) — INTEGER
  • loggedin (Field12) — INTEGER
  • ttlprcd (Field14) — INTEGER
  • prcd (Field29) — INTEGER
  • birth (Field13) — DATE
  • ishelp (Field16) — BOOLEAN
  • orderhelp (Field30) — BOOLEAN
  • latitude (Field17) — TEXT
  • longitude (Field18) — TEXT
  • range (Field19) — TEXT
  • zip (Field26) — JSON
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE
  • activeDate (Field23) — DATE
  • isPass (Field28) — BOOLEAN
  • active (Field22) — BOOLEAN
  • activeTxt (Field27) — TEXT
  • isblock (Field4) — BOOLEAN
  • blocktxt (Field15) — TEXT
  • information (Field31) — TEXT
  • images (Field32) — JSON

USER_ACCOUNT (출금신청목록)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • actname (Field) — TEXT
  • bank (Field2) — TEXT
  • code (Field3) — TEXT
  • price (Field6) — TEXT
  • createdAt (Field4) — DATE
  • udatedAt (Field5) — DATE

USER_ACCOUNT (회원계좌)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • bank (Field) — TEXT
  • account (Field2) — TEXT
  • name (Field3) — TEXT

USER_REPORT (신고)

  • id (Key2) — INTEGER — Primary key — NOT NULL
  • userid (Key) — INTEGER — Foreign key → USER.id — NOT NULL
  • targetid (Key3) — INTEGER — Foreign key → USER.id — NOT NULL
  • content (Field) — TEXT
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

USER_REVIEW (이용후기)

  • id (Key) — INTEGER — Foreign key → USER.id — NOT NULL
  • ERRANDS_FORMID (Key2) — INTEGER — Foreign key → ERRANDS_FORM.id — NOT NULL
  • star (Field) — INTEGER
  • content (Field2) — TEXT

USER_WORD (자주쓰는 내용)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • isclbrt (Field) — BOOLEAN
  • price (Field2) — INTEGER
  • title (Field3) — STRING
  • content (Field4) — TEXT
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE

USE_POINT_IN (포인트 충전내역)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid — INTEGER — Foreign key → USER.id — NOT NULL
  • price (Field) — INTEGER
  • use (Field2) — TEXT
  • isCash (Field5) — BOOLEAN
  • account (Field6) — JSON
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

USE_POINT_OUT (포인트 사용내역)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • price (Field) — INTEGER
  • use (Field2) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

errands_cate (심부름 카테고리)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • errands_formid (Key2) — INTEGER — Foreign key → ERRANDS_FORM.id — NOT NULL
  • cate (Field) — STRING
  • name (Field2) — STRING

message (메세지)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → user_room.userid — NOT NULL
  • content (Field) — STRING
  • orderInfo (Field2) — JSON
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

user_cate (회원카테고리)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • cate (Field) — STRING
  • name (Field2) — STRING

user_clclt (정산)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key22) — INTEGER — Foreign key → ERRANDS_FORM.userid — NOT NULL
  • istype (Field) — TEXT
  • isMode (Field2) — TEXT
  • price (Field3) — INTEGER
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

user_helpreq (Untitled)

    user_room (룸소속 회원)

    • userid (Key2) — INTEGER — Foreign key → ERRANDS_FORM.userid — NOT NULL
    • roomid (Key) — INTEGER — Foreign key → ROOM.id — NOT NULL
    • type (Field) — STRING
    • createdAt (Field3) — DATE
    • updatedAt (Field4) — DATE