LikeLion
Tables (5)
Activity (스트레스 해소 활동)
- activityId (활동id) — long — Primary key — NOT NULL
- name (이름) — String
- content (내용) — String
- userId (유저id) — long — Foreign key → User.userId — NOT NULL
Item (아이템)
- itemId (아이템id) — long — Primary key — NOT NULL
- name (이름) — String
- type (타입)
- price (가격) — long
- plantId (식물id) — long — Foreign key → Plant.plantId — NOT NULL
Plant (식물)
- plantId (식물id) — long — Primary key — NOT NULL
- type (타입)
- level (레벨) — long
- exp (경험치) — long
- userId (유저id) — long — Foreign key → User.userId — NOT NULL
User (사용자)
- userId (유저id) — long — Primary key — NOT NULL
- username (유저이름) — String
- password (비밀번호) — String
- email (이메일) — String
Watering (물주기)
- wateringId (물주기id) — long — Primary key — NOT NULL
- date (날짜) — String
- getCoin (얻는코인) — long
- userId (유저id) — long — Foreign key → User.userId — NOT NULL
- plantId (식물id) — long — Foreign key → Plant.plantId — NOT NULL