루틴업

테이블 (11)

Accounts (Untitled9)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • account_number (Field) — varchar — NOT NULL
  • bank (Field2) — varchar — NOT NULL
  • is_valid (Field3) — bit(1) — NOT NULL
  • USERID (Key2) — VARCHAR2 (50) — 외래 키 → Users.USER_ID — NOT NULL

Achievements (Untitled8)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • USERID (Key2) — VARCHAR2 (50) — 외래 키 → Users.USER_ID — NOT NULL
  • type (Field) — bigint — NOT NULL
  • achievement_date (Field2) — datetime — NOT NULL

Challenges (Untitled3)

  • CHALLENGE_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • CHALLENGE_NAME (Field) — VARCHAR2 (30) — NOT NULL
  • START_DATE (Field2) — DATE — NOT NULL
  • END_DATE (Field3) — DATE — NOT NULL
  • CERTIFICATION_FREQUENCY (Field5) — NUMBER — NOT NULL
  • CERTIFICATION_EXPLANATION (Field6) — VARCHAR2 (500)
  • CERTIFICATION_COUNT (Field7) — NUMBER — NOT NULL
  • CERTIFICATION_METHOD (Field8) — VARCHAR2 (20) — NOT NULL
  • CHALLENGE_EXPLANAION (Field9) — VARCHAR2 (500)
  • MAXIMUM_PEOPLE (Field11) — NUMBER — NOT NULL
  • PRIVATE (Field10) — BOOLEAN — NOT NULL
  • PRIVATE_CODE (Field12) — VARCHAR2 (1000)
  • CATEGORIES (Field13) — VARCHAR2 (500)
  • PRESENTATIVE_PHOTO (Field14) — VARCHAR2 (1000)
  • OWNERID (Key2) — NUMBER — 외래 키 → Users.USER_ID — NOT NULL

Chats (Untitled12)

  • id (Key2) — number — 기본 키 — NOT NULL
  • CHALLENGE_ID (Key) — NUMBER — 외래 키 → Challenges.CHALLENGE_ID — NOT NULL
  • USERID (Key3) — NUMBER — 외래 키 → Users.USER_ID — NOT NULL
  • text (Field) — longtext — NOT NULL
  • created_date (Field2) — datetime — NOT NULL

Comments (Untitled5)

  • post_id (Key) — bigint — 외래 키 → Posts.id — NOT NULL
  • text (Field) — longtext — NOT NULL

Friends (Untitled7)

  • id (Key3) — bigint — 기본 키 — NOT NULL
  • OWNER (Key) — VARCHAR2 (50) — 외래 키 → Users.USER_ID — NOT NULL
  • FRIEND (Key2) — VARCHAR2 (50) — 외래 키 → Users.USER_ID — NOT NULL

LIKE (Untitled11)

  • post_id (Key) — bigint — 외래 키 → Posts.id — NOT NULL
  • USERID (Key2) — NUMBER — 외래 키 → Users.USER_ID — NOT NULL

Notifications (Untitled10)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar — NOT NULL
  • description (Field2) — longtext — NOT NULL
  • is_read (Field3) — bit(1) — NOT NULL
  • USERID (Key2) — NUMBER — 외래 키 → Users.USER_ID — NOT NULL

Paticipants (Untitled6)

  • USERID (Key) — NUMBER — 외래 키 → Users.USER_ID — NOT NULL
  • CHALLENGEID (Key2) — NUMBER — 외래 키 → Challenges.CHALLENGE_ID — NOT NULL
  • is_owner (Field) — bit(1) — NOT NULL
  • DEPOSIT (Field2) — NUMBER — NOT NULL
  • PAYMENT_STATUS (Field3) — BOOLEAN — NOT NULL

Posts (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar — NOT NULL
  • image (Field2) — varchar — NOT NULL
  • text (Field5) — longtext
  • is_verified (Field3) — bit — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → Users.USER_ID — NOT NULL
  • CHALLENGE_ID (Key3) — NUMBER — 외래 키 → Challenges.CHALLENGE_ID — NOT NULL
  • created_date (Field6) — datetime — NOT NULL
  • updated_date (Field7) — datetime — NOT NULL

Users (Untitled)

  • USER_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • USERNAME (Field2) — VARCHAR2 (100) — NOT NULL
  • EMAIL (Field) — VARCHAR2 (100) — NOT NULL
  • PASSWORD (Field4) — VARCHAR2 (1000) — NOT NULL
  • REGISTERDATE (Field5) — DATE — NOT NULL
  • avartar (Field6) — varchar
  • level (Field7) — bigint — NOT NULL
  • xp (Field8) — bigint — NOT NULL
  • point (Field9) — bigint — NOT NULL
  • provider (Field3) — varchar — NOT NULL
  • role (Field10) — varchar — NOT NULL