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