DEVC_4

Tables (12)

avatar

  • avatar_id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • avatar_type — VARCHAR(50) — NOT NULL
  • current_skin_id — BIGINT
  • position_x — FLOAT
  • position_y — FLOAT
  • current_room_id — BIGINT

avatar_item

  • item_id — BIGINT — Primary key
  • item_name — VARCHAR(100) — NOT NULL
  • item_type — ENUM('OUTFIT','ACCESSORY','EMOTION') — NOT NULL
  • item_image_url — VARCHAR(500)
  • price — INT — NOT NULL
  • rarity — ENUM('COMMON','RARE','EPIC')
  • is_active — BOOLEAN — 상점 판매 여부

community_comment

  • comment_id — BIGINT — Primary key
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • parent_comment_id — BIGINT — 댓글의 댓글
  • content — TEXT — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

community_post

  • post_id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

plant

  • plant_id (Key) — BIGINT — Primary key — NOT NULL
  • level — INT
  • current_exp — INT
  • name — VARCHAR(25)

room_comment

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — 작성자
  • room_id — BIGINT
  • comment (omment) — TEXT? VARCHAR?

room_object

  • object_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT
  • object_type (name) — ENUM('DECORATION',COMMENT' ETC..)
  • is_active — BOOLEAN

room_participant

  • participant_id — BIGINT — Primary key
  • room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role — ENUM('OWNER', 'MEMBER') — NOT NULL
  • joined_at — TIMESTAMP
  • left_at — TIMESTAMP
  • total_study_time_in_room — INT

study_room

  • room_id — BIGINT — Primary key — NOT NULL
  • room_name — VARCHAR(50) — NOT NULL
  • room_type — ENUM('PUBLIC', 'PRIVATE') — NOT NULL
  • max_participants — INT — NOT NULL
  • current_participants — INT — NOT NULL
  • owner_id — BIGINT — NOT NULL
  • password — VARCHAR(255)
  • room_theme — VARCHAR(100)
  • tags — JSON
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_avatar_item

  • user_item_id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • item_id — BIGINT — NOT NULL
  • is_equipped — BOOLEAN — 장착 여부

user_friend

  • friend_id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • friend_user_id — BIGINT — NOT NULL
  • status — ENUM('PENDING','ACCEPTED') — NOT NULL
  • requested_at — TIMESTAMP
  • accepted_at — TIMESTAMP
  • tag — VARCHAR(20)

users

  • user_id — long — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(25) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • total_study_time — INT
  • total_points — INT
  • plant_id (level) — BIGINT
  • title — VARCHAR(100)
  • status — ENUM('ONLINE', 'OFFLINE', 'STUDYING')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP