Hackerthon
Tables (8)
Untitled (user)
- Key (id) — bigint — Primary key — NOT NULL
- Field (password) — varchar(20) — NOT NULL
- Field2 (nickName) — varchar(20)
- Field (gender) — varchar(10)
- Field3 (email) — varchar(30)
- Field (status) — char(10) — NOT NULL
- Field4 (phone) — varchar(20)
- Field (credit) — int — NOT NULL
- Field5 (create_at) — datetime(6) — NOT NULL
- Field (update_at) — datetime(6) — NOT NULL
Untitled (article)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(100)
- Field (body) — varchar(200)
- Field (status) — CHAR(10) — NOT NULL
- Field2 (articlePrice) — int
- Field (create_at) — datetime(6) — NOT NULL
- Field2 (update_at) — datetime(6) — NOT NULL
Untitled (category)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name)
- Field (updated_at) — datetime(6) — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
Untitled (likes)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (article_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field2 (undate_at) — datetime(6) — NOT NULL
Untitled (chat_room)
- Key (id) — bigint — Primary key — NOT NULL
- Key (article_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at)
Untitled (chat_message)
- Key (id) — bigint — Primary key — NOT NULL
- Key (chat_room_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (message) — varchar(255) — NOT NULL
- Field (reading) — boolean — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at) — datetime(6) — NOT NULL
Untitled (pay_user)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at) — datetime(6) — NOT NULL
- Field2 (credit) — long
- Field3
- Field4
Untitled (bank_account)
- Key (id) — bigint — Primary key — NOT NULL
- Key (pay_user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (account_number) — varchar(100)
- Field (balance) — bigint
- Field (bank_name) — varchar(20)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)