TOPICK_MAIN

Tables (15)

ACCOUNT (계좌정보)

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

INQUIRY (1:1문의)

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

INQUIRY_ENCER (1:1문의 답변)

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

NOTICE (공지사항)

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

ORDER_PICK (구매내역)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • pickboardid (Key3) — INTEGER — Foreign key → PICKBOARD.id — NOT NULL
  • createdAt (Field) — DATE

PAYMENT (결제)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • iamcode (Field9) — STRING
  • price (Field) — INTEGER
  • type (Field2) — INTEGER
  • chekced (Field3) — BOOLEAN
  • nameBank (Field4) — STRING
  • bnkacNmbr (Field5) — STRING
  • accountName (Field6) — STRING
  • createdAt (Field7) — DATE
  • updatedAt (Field8) — DATE

PAYMENT_CHECK (결제확인자용)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key22) — INTEGER — Foreign key → PAYMENT.userid — NOT NULL

PICKBOARD (픽스터 픽 보드)

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

PICKBOARD_MATCH (픽 매치)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • PICKBOARDID (Key2) — INTEGER — Foreign key → PICKBOARD.id — NOT NULL
  • day (Field) — DATE
  • event (Field2) — STRING
  • lg (Field3) — STRING
  • match (Field4) — STRING
  • over (Field9) — BOOLEAN
  • type (Field5) — INTEGER
  • dvdnd (Field6) — INTEGER
  • createdAt (Field7) — DATE
  • updatedAt (Field8) — DATE
  • team (Field10) — STRING

POINT_LOG (포인트 로그)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • type (Field) — BOOLEAN
  • point (Field2) — INTEGER
  • memo (Field3) — STRING
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

REFUND (환급)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • orderprice (Field) — INTEGER
  • type (Field3) — BOOLEAN
  • nameBank (Field4) — STRING
  • bnkacNmbr (Field5) — STRING
  • accountName (Field6) — STRING

REFUND_CHECKED (환급관리)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • REFUNDID (Key2) — INTEGER — Foreign key → REFUND.id — NOT NULL
  • userid (Key22) — INTEGER — Foreign key → REFUND.userid — NOT NULL
  • price (Field) — INTEGER
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

SALE_ORDER_PICK (판매내역)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • PCIKBOARDID (Key3) — INTEGER — Foreign key → PICKBOARD.id — NOT NULL
  • createdAt (Field) — DATE

TERMS (이용약관)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • title (Field) — STRING
  • content (Field2) — STRING
  • required (Field5) — BOOLEAN
  • type (Field6) — STRING
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

USER (회원)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • nickname (Field8) — STRING
  • email (Field) — STRING
  • password (Field2) — STRING
  • salt (Field3) — STRING
  • tel (Field4) — STRING
  • point (Field5) — INTEGER
  • avatar (Field9) — JSON
  • PickSter (Field10) — BOOLEAN
  • gm (Field11) — INTEGER
  • ban (Field12) — BOOLEAN
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE