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')