chp.0
Tables (8)
alarm
- id — BIGINT — Primary key — NOT NULL
- alarm_type — ENUM('NOTICE','REMINDER')
- alarm_message — VARCHAR(512)
- title — VARCHAR(256)
- content — TEXT
- sender_id — BIGINT
- receiver_id — BIGINT
- created_at — DATE
- updated_at — DATE
alarm_setting
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- fire_enabled — BOOLEAN — NOT NULL
- reminder_enabled — BOOLEAN — NOT NULL
- reminder_time — DATETIME
- created_at — DATE
- updated_at — DATE
diary
- id — BIGINT — Primary key — NOT NULL
- content — TEXT
- emotion — ENUM('HAPPY','ANGRY')
- record_date — DATE
- member_id — BIGINT — NOT NULL
- created_at — DATE
- updated_at — DATE
friend
- id — BIGINT — Primary key — NOT NULL
- friend_status — ENUM('REJECTED','ACCEPTED') — NOT NULL
- sender_id — BIGINT — NOT NULL
- receiver_id — BIGINT — NOT NULL
- created_at — DATE
- updated_at — DATE
member
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50)
- email — VARCHAR(100)
- user_id — VARCHAR(125)
- nickname — VARCHAR(50)
- reward — INT
- feeling — VARCHAR(100)
- introduction — VARCHAR(256)
- created_at — DATE
- updated_at — DATE
member_answer
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- question_id — BIGINT — NOT NULL
- content — VARCHAR(512)
- created_at — DATE
- updated_at — DATE
member_item
- id — BIGINT — Primary key — NOT NULL
- item — ENUM('FISH') — NOT NULL
- member_id — BIGINT — NOT NULL
- created_at — DATE
- updated_at — DATE
question
- id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(256) — NOT NULL
- created_at — DATE
- updated_at — DATE