Balance

Tables (9)

Article (Untitled3)

  • article_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL — 작성자ID
  • created_at (Field) — DATETIME
  • updated_at (Field2) — DATETIME
  • title (Field4) — VARCHAR(100)
  • content (Field3) — VARCHAR(100)

BalanceGame (Untitled4)

  • balance_game_id (Key) — Primary key — NOT NULL
  • article_id (Key2) — BIGINT — Foreign key → Article.article_id — NOT NULL — 게시글 ID
  • left_image (Field) — VARCHAR
  • right_image (Field2) — VARCHAR
  • left_text (Field3) — VARCHAR
  • right_text (Field4) — VARCHAR

Comment (Untitled5)

  • comment_id (Key) — Primary key — NOT NULL
  • article_id (Key2) — BIGINT — Foreign key → Article.article_id — NOT NULL
  • user_id (Key3) — BIGINT — Foreign key → User.user_id — NOT NULL — 작성자 ID
  • content (Field) — VARCHAR(200) — 200자 내 작성
  • created_at (Field2) — DATETIME
  • update_at (Field3) — DATETIME

Follow (Untitled2)

  • follow_id (Key) — BIGINT — Primary key — NOT NULL — 팔로우 정보 ID
  • following_user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL — 유저 ID
  • followed_user_id (Key3) — BIGINT — Foreign key → User.user_id — NOT NULL — 유저 ID

Item (Untitled8)

  • item_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • price (Field2) — INT
  • image (Field3) — VARCHAR
  • content (Field4) — VARCHAR(300) — 상세설명

User (Untitled)

  • user_id (Key) — BIGINT — Primary key — NOT NULL — 유저 ID
  • image (Field) — VARCHAR — Image S3 주소
  • email (Field2) — VARCHAR — 이메일 주소
  • name (Field3) — VARCHAR — 이름(실명)
  • nickname (Field4) — VARCHAR — 별명
  • age (Field5) — INT — 나이
  • gender (Field6) — ENUM — 성별
  • created_at (Field7) — DATETIME
  • updated_at (Field8) — DATETIME
  • point (Field9) — BIGINT — 포인트 보유량

UserArticleLike (Untitled6)

  • article_like_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL — 유저 ID
  • article_id (Key3) — BIGINT — Foreign key → Article.article_id — NOT NULL

UserBalanceGame (Untitled7)

  • user_balance_game_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL — 유저 ID
  • balance_game_id (Key3) — Foreign key → BalanceGame.balance_game_id — NOT NULL
  • left_or_right (Field5) — ENUM — left,right

UserItem (Untitled9)

  • user_item_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL — 유저 ID
  • item_id (Key3) — BIGINT — Foreign key → Item.item_id — NOT NULL