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