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