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