슬덕

테이블 (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