레스톰-나만의 게임메이트

테이블 (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