SKT_FLY_AI

Tables (5)

MILEAGE (마일리지)

  • mileage_id (PK) — UUID — Primary key — NOT NULL
  • user_id (FK1) — UUID — Foreign key → User.id — NOT NULL
  • team_id (FK2) — UUID — Foreign key → TEAM.team_id — NOT NULL
  • amount (Field2) — INT
  • source (Field3) — VARCHAR
  • mileage_created_at (Field4) — TIMESTAMP
  • modified_time (Field5?) — TIMESTAMP
  • delete_yn (Field6?) — Boolean

TEAM (팀(구단))

  • team_id (PK) — UUID — Primary key — NOT NULL
  • team_name (Field1) — VARCHAR

TEAM_MILEAGE (팀별 마일리지)

  • team_id (PK2) — UUID — Foreign key → TEAM.team_id — NOT NULL
  • total_mileage (Field1) — INT
  • update_at (Field2) — TIMESTMP

TUMBLER_VERIFICATIONS (텀블러 인증)

  • tum_id (PK) — UUID — Primary key — NOT NULL
  • user_id (FK1) — UUID — Foreign key → User.id — NOT NULL
  • image_url (Field1) — VARCHAR
  • receipt_url (Field2) — VARCHAR
  • status (Field3) — ENUM('P', 'S', 'F')
  • tum_created_at (Field4) — TIMESTAMP
  • mileage_id (FK2) — UUID — Foreign key → MILEAGE.mileage_id — NOT NULL

User (사용자)

  • id (PK) — UUID — Primary key — NOT NULL
  • email (Field1) — VARCHAR
  • password (Field2) — VARCHAR
  • nickname (Field3) — VARCHAR
  • favorite_team (Field4) — VARCHAR
  • created_at (Field5) — TIMESTAMP
  • updated_at (Field6) — TIMESTAMP
  • date_of_birth (Field7?) — Date
  • phone_number (Field8?) — String
  • gender (Field9?) — ENUM('M', 'F')