pudding 최종
테이블 (8)
daily_challenge
- id — INT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- challenge_id — INT
- status — VARCHAR(50)
daily_challenge_participation
- id — INT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- users_id — INT
- daily_challenge_id — INT
dialog_korean
- id — INT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- korean_sentence — TEXT
dialog_session
- id — INT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- users_id — INT
- problem_id — INT
dialog_situation
- id — INT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
english_test_result
- id — INT
- users_id — INT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- dialog_id — INT
problem
- id — INT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- english_question — VARCHAR(255)
- english_answer — VARCHAR(255)
- dialog_id — INT
users
- id — INT
- check_level — VARCHAR(50)
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- memo_yn — BOOLEAN
- memo_limit — INT
- nickname — VARCHAR(100)
- sns_type — VARCHAR(50)
- sns_id — VARCHAR(100)
- uuid — VARCHAR(100)