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