mySonge - 수아

테이블 (4)

Calendar (캘린더)

  • id (PK) — LONG — 기본 키 — NOT NULL
  • user_id (PK2) — LONG — 외래 키 → User.user_id — NOT NULL
  • c_date (Field) — DATE
  • c_title (Field2) — VARCHAR(50)
  • c_time_start (Field3) — TIME
  • c_time_end (Field4) — TIME
  • c_color (Field5) — VARCHAR(7)
  • c_context (Field6) — VARCHAR(500)
  • c_location (Field7) — VARCHAR(50)

Character (캐릭터)

  • ch_id (PK) — LONG — 기본 키 — NOT NULL
  • user_id (PK2) — LONG — 외래 키 → User.user_id — NOT NULL
  • ch_name (Field) — VARCHAR(50)
  • ch_quote (Field2) — VARCHAR(200)

Routine (루틴)

  • id (PK) — LONG — 기본 키 — NOT NULL
  • user_id (PK2) — LONG — 외래 키 → User.user_id — NOT NULL
  • r_name (Field) — VARCHAR(50)
  • r_repear (Field2) — JSON
  • r_time (Field3) — TIME
  • r_context (Field4) — VARCHAR(500)

User (사용자)

  • user_id (PK) — LONG — 기본 키 — NOT NULL
  • user_name (Field) — VARCHAR(50)
  • user_email (Field2) — VARCHAR(150)
  • user_birth (Field3) — VARCHAR(50)