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