UpGram
Tables (9)
Images (imageMime)
- id (pk) — INTEGER — Primary key — NOT NULL
- hash (Field) — STRING
- name (Field2) — STRING
- mime (Field3) — STRING
- url (Field4) — STRING
- createdAt (Field5) — DATE
- updatedAt (Field6) — DATE
event (이벤트)
- id (pk) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- content (Field2) — TEXT
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
notice (공지사항)
- id (pk) — INTEGER — Primary key — NOT NULL
- title (Field) — STRING
- content (Field2) — TEXT
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
point_log (적립금 내역)
- id (PK) — INTEGER — Primary key — NOT NULL
- user_instarid (pk) — INTEGER — Foreign key → user_instar.id — NOT NULL
- point (Field) — INTEGER
- type (Field2) — STRING
- option (Field5) — BOOLEAN
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
qa (질문답변)
- id (pk) — INTEGER — Primary key — NOT NULL
- question (Field) — TEXT
- answer (Field2) — TEXT
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
refund (환급신청)
- id (pk) — INTEGER — Primary key — NOT NULL
- userid (fk) — INTEGER — Foreign key → user.id — NOT NULL
- bank (Field) — STRING
- account (Field2) — STRING
- accountName (Field8) — STRING
- price (Field3) — INTEGER
- prCntnt (Field4) — STRING
- csbprCntnt (Field5) — STRING
- createdAt (Field6) — DATE
- updatedAt (Field7) — DATE
user (회원)
- id (pk) — INTEGER — Primary key — NOT NULL
- email (Field) — STRING
- name (Field17) — STRING
- account (Field18) — STRING
- bank (Field20) — STRING
- user_email (Field2) — STRING
- password (Field15) — STRING
- birthday (Field3) — DATE
- salt (Field14) — STRING
- tel (Field4) — STRING
- gender (Field16) — STRING
- state (Field5) — BOOLEAN
- totalpoints (Field8) — INTEGER
- totalrefund (Field9) — INTEGER
- point (Field10) — INTEGER
- code (Field11) — STRING
- targetcode (Field12) — STRING
- admin (Field13) — JSON
- createdAt (Field6) — DATE
- updatedAt (Field7) — DATE
user_instar (인스타 계정)
- id (pk) — INTEGER — Primary key — NOT NULL
- userid (fk) — INTEGER — Foreign key → user.id — NOT NULL
- user_id (Field) — STRING
- avatar (Field7) — STRING
- access_token (Field8) — STRING
- reason (Field5) — STRING
- state (Field2) — BOOLEAN
- code (Field6) — STRING
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
user_point_log (회원 포인트 내역)
- id (pk) — INTEGER — Primary key — NOT NULL
- userid (fk) — INTEGER — Foreign key → user.id — NOT NULL
- point (Field) — INTEGER
- type (Field2) — STRING
- option (Field3) — BOOLEAN
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE