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