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