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