sinhan
Tables (5)
Calendar (calendar)
- calendarId (calendar_id) — BIGINT — Primary key — NOT NULL — Auto-increment
- userId (user_id) — BIGINT — Primary key — NOT NULL — Auto-increment
- date — datetime — NOT NULL
- comment — varchar(100)
Celebrity (celebrity)
- celebrityId (celebrity_id) — BIGINT — Primary key — NOT NULL — Auto-increment
- name — varchar(20) — NOT NULL
- instaId (insta_id) — varchar(20) — NOT NULL
User (user)
- userId (user_id) — BIGINT — Primary key — NOT NULL — Auto-increment
- userName (user_name) — varchar(20) — NOT NULL
- email — varchar(20) — NOT NULL — UNIQUE
- password — varchar(20)
celebAccount (celeb_account)
- id — BIGINT — Primary key — NOT NULL — Auto-increment
- userId (user_id) — BIGINT — Primary key — NOT NULL — Auto-increment
- celebrityId (celebrity_id) — BIGINT — Primary key — NOT NULL — Auto-increment
- amount — BIGINT — NOT NULL
targetAccount (target_account)
- id — BIGINT — Primary key — NOT NULL — Auto-increment
- userId (user_id) — BIGINT — Primary key — NOT NULL — Auto-increment
- targetAmount (target_amount) — BIGINT — NOT NULL
- amount — BIGINT — NOT NULL