pointManager

테이블 (4)

USER

  • USERSEQ — BIGINT
  • USERID — VARCHAR(255)
  • USERNAME — VARCHAR(255)
  • NICKNAME — VARCHAR(255)
  • PASSWORD — VARCHAR(255)
  • OLDPASSWORD — VARCHAR(255)
  • EMAIL — VARCHAR(255)
  • PHONENUMBER — VARCHAR(255)
  • ROLE — VARCHAR(255)
  • POINT — INT
  • CREATEDDATE — TIMESTAMP
  • MODIFIEDDATE — TIMESTAMP

access_tokens

  • token — varchar(255) — 기본 키 — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • user_id — varchar(255)

tournament_user

  • seq — INT
  • user_seq — INT — NOT NULL
  • board_seq — INT — NOT NULL
  • participant_order — INT — NOT NULL
  • participation_status — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

토너먼트게시판 (tournament_board)

  • board_seq — INT
  • board_title — VARCHAR(255) — NOT NULL
  • board_article — TEXT
  • board_image — VARCHAR(255)
  • cost — INT — NOT NULL
  • user_seq — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP