pullo-erd-table

Tables (5)

Member (유저)

  • memberId (유저 PK) — Long — Primary key — NOT NULL
  • nickname (닉네임) — VARCHAR(200)
  • mobileNum (유저 앱 아이디) — VARCHAR(1000)
  • created_At (생성일) — TimeStamp
  • updated_At (최종 수정일) — TImeStamp
  • lastLoginDate (마지막 앱 접속 날) — TImeStamp
  • firebaseToken (파이어베이스토큰) — VARCHAR(1000)

Notification (알림)

  • notificationId (유저 PK) — Long — Primary key — NOT NULL
  • title (제목) — VARCHAR(200)
  • body (메세지 내용) — VARCHAR(1000)
  • created_At (생성일) — TimeStamp
  • updated_At (최종 수정일) — TImeStamp
  • userId (유저 PK2) — Long — Foreign key → Member.memberId — NOT NULL

PlantLevel (Untitled)

  • level_id (식물종류PK) — Long — Primary key — NOT NULL
  • plantLevel (식물 레벨) — Long
  • plantExp (식물 경험치)
  • plantId (식물 PK) — Long — Foreign key → Plants.plantId — NOT NULL

PlantMessage (Untitled2)

  • PlantMessageId (식물메시지 PK) — Primary key — NOT NULL
  • createdAt (생성일)
  • updateAt (수정일)
  • nickname (익명 사용자 명)
  • content (내용)
  • plantId (식물 PK) — Long — Foreign key → Plants.plantId — NOT NULL

Plants (식물)

  • plantId (식물 PK) — Long — Primary key — NOT NULL
  • created_At (생성일) — TimeStamp
  • updated_At (최종 수정일) — TImeStamp
  • isActive (활성화 여부) — Boolean
  • today_Exp (하루 경험치량) — Integer
  • plant_name (식물 이름)
  • userId (유저 식별 키) — Long — Foreign key → Member.memberId — NOT NULL