슬덕
테이블 (7)
Accounts (ACCOUNTS)
- accountId (ACCOUNT_ID) — INT — 기본 키 — NOT NULL
- accountInfo (ACCOUNT_INFO) — VARCHAR(255)
- userId (USER_ID) — INT — 외래 키 → User.userId — NOT NULL
Celebrity (CELEBRITY)
- celebrityId (CELEBRITY_ID) — INT — 기본 키 — NOT NULL
- id (ID) — VARCHAR(255)
- password (PASSWORD) — VARCHAR(255)
- nickname (NICKNAME) — VARCHAR(255)
CelebritySchedules (CELEBRITY_SCHEDULES)
- celebrityScheduleId (CELEBRITY_SCHEDULE_ID) — INT — 기본 키 — NOT NULL
- startAt (START_AT) — TIMESTAMP
- endAt (END_AT) — TIMESTAMP
- title (TITLE) — VARCHAR(255)
- content (CONTENT) — TEXT
- celebrityId (CELEBRITY_ID) — INT — 외래 키 → Celebrity.celebrityId — NOT NULL
Follows (FOLLOWS)
- followId (FOLLOW_ID) — INT — 기본 키 — NOT NULL
- userId (USER_ID) — INT — 외래 키 → User.userId — NOT NULL
- celebrityId (CELEBRITY_ID) — INT — 외래 키 → Celebrity.celebrityId — NOT NULL
SaveInfo (SAVE_INFO)
- saveInfoId (SAVE_INFO_ID) — INT — 기본 키 — NOT NULL
- userId (USER_ID) — INT — 외래 키 → User.userId — NOT NULL
- saveAmount (SAVE_AMOUNT) — INT
- targetAmount (TARGET_AMOUNT) — INT
User (USERS)
- userId (USER_ID) — INT — 기본 키 — NOT NULL
- id (ID) — VARCHAR(255)
- password (PASSWORD) — VARCHAR(255)
- nickname (NICKNAME) — VARCHAR(255)
- birth (BIRTH) — TIMESTAMP
UserSchedules (USER_SCHEDULES)
- userScheduleId (USER_SCHEDULE_ID) — INT — 기본 키 — NOT NULL
- startAt (START_AT) — TIMESTAMP
- endAt (END_AT) — TIMESTAMP
- title (TITLE) — VARCHAR(255)
- content (CONTENT) — TEXT
- userId (USER_ID) — INT — 외래 키 → User.userId — NOT NULL