레스톰-나만의 게임메이트
테이블 (23)
CHAT_MESSAGE (채팅 메세지)
- id (Key2) — 기본 키 — NOT NULL
- chat_roomid (Key) — INTEGER — 외래 키 → CHAT_ROOM.id — NOT NULL
- id (Key4) — INTEGER — 외래 키 → CHAT_ROOM.userorderId — NOT NULL
- text (Field) — JSON
- is_tel (Field5) — BOOLEAN
- is_order (Field4) — BOOLEAN
- tel_time (Field6) — DATE
- order_time (Field7) — DATE
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
CHAT_ROOM (채팅방)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- receiverId (Key2) — INTEGER — 외래 키 → USER.id — NOT NULL
- userorderId (Key4) — INTEGER — 외래 키 → USER_ORDER.id — NOT NULL
- senderId (Key3) — INTEGER — 외래 키 → USER.id — NOT NULL
- name (Field) — TEXT
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
COMMENT_RE (대댓글)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- FeedId (Key22) — INTEGER — 외래 키 → FEED_COMMENT.FeedId — NOT NULL
- content (Field) — TEXT
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
FEED (피드)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- content (Field) — TEXT
- files (Field2) — JSON
- likeCount (Field3) — INTEGER
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
FEED_COMMENT (댓글)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- FeedId (Key2) — INTEGER — 외래 키 → FEED.id — NOT NULL
- content (Field) — TEXT
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
GAME (게임)
- id (Key) — 기본 키 — NOT NULL
- game_name (Field) — BOOLEAN
- game_thum (Field2) — TEXT
- order (Field3) — INTEGER
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
GAME_LEVEL (게임레벨)
- id (Key) — 기본 키 — NOT NULL
- gameid (Key2) — 외래 키 → GAME.id — NOT NULL
- level_name (Field) — TEXT
- order (Field2) — INTEGER
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
GAME_POSITION (포지션정보)
- id (Key) — 기본 키 — NOT NULL
- gameid (Key2) — 외래 키 → GAME.id — NOT NULL
- position_name (Field) — TEXT
- order (Field2) — INTEGER
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
REQUEST_USER (레스톰 파트너신청서)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- userid (Key2) — INTEGER — 외래 키 → USER.id — NOT NULL
- terminfo (Field3) — TEXT
- createdAt (Field) — DATE
- updatedAt (Field2) — DATE
TERM (이용약관)
- id (Key) — 기본 키 — NOT NULL
- require (Field) — BOOLEAN
- title (Field2) — TEXT
- content (Field3) — TEXT
USER (회원)
- id (Key) — 기본 키 — NOT NULL
- join_type (Field3) — TEXT
- email (Field) — TEXT
- password (Field2) — TEXT
- salt (Field4) — TEXT
- is_partner (Field5) — BOOLEAN
- gender (Field6) — TEXT
- tel (Field18) — INTEGER
- nick_name (Field7) — TEXT
- birth (Field8) — DATE
- voice (Field9) — TEXT
- my_info (Field10) — TEXT
- my_photos (Field11) — JSON
- my_thmb (Field12) — TEXT
- user_tag (Field13) — TEXT
- storm (Field14) — INTEGER
- is_online (Field22) — BOOLEAN
- fcm (Field15) — TEXT
- my_talent (Field20) — TEXT
- count_storm (Field19) — INTEGER
- game_image (Field21) — TEXT
- createdAt (Field16) — DATE
- updatedAt (Field17) — DATE
- is_alert (Field23) — BOOLEAN
USER_ALERT (알림)
- id (Key2) — 기본 키 — NOT NULL
- userId (Key) — INTEGER — 외래 키 → USER.id — NOT NULL
- title (Field) — TEXT
- content (Field2) — TEXT
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
USER_BAG (가방)
- id (Key) — 기본 키 — NOT NULL
- userid (Key2) — 외래 키 → USER.id — NOT NULL
- targetid (Key3) — INTEGER — 외래 키 → USER.id — NOT NULL
- type_text (Field) — TEXT
- is_send (Field2) — TEXT
- content (Field4) — TEXT
- storm (Field3) — INTEGER
- createdAt (Field16) — DATE
- updatedAt (Field17) — DATE
USER_BOOK (방명록)
- id (Key) — 기본 키 — NOT NULL
- myId (Key2) — INTEGER — 외래 키 → USER.id — NOT NULL
- targetId (Key3) — INTEGER — 외래 키 → USER.id — NOT NULL
- content (Field) — TEXT
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
USER_FOLLOW (팔로우)
- followingId (Key) — 외래 키 → USER.id — NOT NULL
- followerId (Key2) — 외래 키 → USER.id — NOT NULL
USER_GAME_FAVORITE (관심있는 게임리스트(포지션X))
- userid (Key) — 외래 키 → USER.id — NOT NULL
- gameid (Key2) — 외래 키 → GAME.id — NOT NULL
USER_LIKEFEED (좋아요)
- Feedid (Key) — INTEGER — 외래 키 → FEED.id — NOT NULL
USER_LIKE_COMMENT (댓글좋아요)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- commentId (Key22) — INTEGER — 외래 키 → FEED_COMMENT.FeedId — NOT NULL
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
USER_LIKE_RE_COMMENT (대댓글 좋아요)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- reId (Key2) — INTEGER — 외래 키 → COMMENT_RE.id — NOT NULL
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE
USER_ORDER (의뢰)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- userid (Key2) — TEXT — 외래 키 → USER.id — NOT NULL
- senderid (Key3) — TEXT — 외래 키 → USER.id — NOT NULL
- storm (Field) — INTEGER
- count (Field2) — INTEGER
- createdAt (Field16) — DATE
- updatedAt (Field17) — DATE
USER_PARTNER_GAME (나의 게임리스트(포지션O))
- userid (Key) — INTEGER — 외래 키 → USER.id — NOT NULL
- gameid (Key2) — INTEGER — 외래 키 → GAME.id — NOT NULL
- positionid (Key22) — INTEGER — 외래 키 → GAME_POSITION.gameid — NOT NULL
- levelid (Key3) — INTEGER — 외래 키 → GAME_LEVEL.id — NOT NULL
- is_accept (Field) — BOOLEAN
- createdAt (Field2) — DATE
- updatedAt (Field3) — DATE
USER_PAY (결제내역)
- id (Key) — 기본 키 — NOT NULL
- userid (Key2) — INTEGER — 외래 키 → USER.id — NOT NULL
- pg (Field) — TEXT
- pay_method (Field2) — TEXT
- name (Field3) — TEXT
- merchant_uid (Field4) — TEXT
- amount (Field5) — TEXT
- digital (Field6) — BOOLEAN
- app_scheme (Field7) — TEXT
- buyer_name (Field8) — TEXT
- buyer_email (Field9) — TEXT
- buyer_addr (Field10) — TEXT
- buyer_postcode (Field11) — TEXT
- buyer_tel (Field12) — TEXT
- pay_mode (Field16) — TEXT
- pay_type (Field15) — TEXT
- createdAt (Field13) — DATE
- updatedAt (Field14) — DATE
USER_REVIEW (파트너 게임리뷰)
- id (Key) — INTEGER — 기본 키 — NOT NULL
- userid (Key2) — INTEGER — 외래 키 → USER.id — NOT NULL
- targetid (Key3) — INTEGER — 외래 키 → USER.id — NOT NULL
- content (Field) — TEXT
- star (Field2) — INTEGER
- createdAt (Field4) — DATE
- updatedAt (Field5) — DATE