405-ERD-RNTS

Tables (10)

appointment (Untitled2)

  • appointmentKey (Key) — Primary key — NOT NULL
  • title (약속이름) — string
  • apType (약속종류) — enum
  • apNumber (인원) — int
  • apDate (약속날짜) — date
  • apTime (약속시간) — time
  • apPlace (약속장소) — string
  • apKey (따로 필요?)

group (그룹)

  • usergroupKey (Key) — Primary key — NOT NULL
  • gName (그룹이름)
  • gNumber (인원)
  • Field5

group_appointment (그룹 약속)

  • gaKey (Key) — Primary key — NOT NULL
  • startPoint (Field3)
  • arrivalPoint (Field)
  • time (Field2)
  • penalty (Field4)
  • usergroupKey (Key2) — Foreign key → group.usergroupKey — NOT NULL

penalty (Untitled4)

  • penaltyKey (Key) — Primary key — NOT NULL
  • detail (Field)
  • Field2

rank (CopyOfUntitled4)

  • rankKey (Key) — Primary key — NOT NULL
  • detail (Field)
  • Field2

user (Untitled)

  • userKey (key) — Primary key — NOT NULL
  • kakaoUser (Field)
  • userId (Field2)
  • userPw (Field3)
  • userName (Field4)
  • userEmail (Field5)
  • userGender (Field6)
  • userProfile (Field7)
  • tendency (성향)

user (사용자)

  • userKey (key) — Primary key — NOT NULL
  • kakaoUser (Field)
  • userId (Field2)
  • userPw (Field3)
  • userName (Field4)
  • userEmail (Field5)
  • userGender (Field6)
  • userProfile (Field7)
  • tendency (성향)

user_appointment (Untitled3)

  • groupKey (key) — Primary key — NOT NULL
  • userKey (Key2) — Foreign key → user.userKey — NOT NULL
  • appointmentKey (Key3) — Foreign key → appointment.appointmentKey — NOT NULL
  • arrivalTime (도착시간)
  • safe (지각여부)
  • penaltyPoint (패널티 종류)
  • penaltyDetail (패널티 내용)
  • penaltyPrice (패널티 벌금)
  • reflection (반성문)
  • rank (약속에서 순위)

user_appointment (약속)

  • appointsmentsKey (key) — Primary key — NOT NULL
  • ispenalty (패널티 여부)
  • gaKey (Key) — Foreign key → group_appointment.gaKey — NOT NULL
  • userKey (key2) — Foreign key → user.userKey — NOT NULL

user_group (.)

  • usergroupKey (Key) — Primary key — NOT NULL
  • userKey (key) — Foreign key → user.userKey — NOT NULL
  • usergroupKey (Key2) — Foreign key → group.usergroupKey — NOT NULL