first step
Tables (3)
Contents
- contentSeq — int — Primary key — NOT NULL
- email — varchar(255) — Foreign key → User.email — NOT NULL
- userEmail — varchar(255)
- color — varchar(16)
- title — varchar(255)
- name — varchar(255)
- mail — varchar(255)
- corporate — varchar(255)
- position — varchar(255)
- phonenumber — varchar(255)
- officenumber — varchar(255)
- address — varchar(255)
- introduce — mediumtext
- lastUpdateDate — datetime
Login
- accessToken — varchar(255) — Primary key — NOT NULL
- email — varchar(255) — Foreign key → User.email — NOT NULL
- refreshToken — varchar(255)
- lastUpdateDate — datetime
- Field4
User
- email — varchar(255) — Primary key — NOT NULL
- nickname — varchar(255)
- gender — varchar(16)
- ageRange — varchar(16)
- birthday — varchar(16)
- lastUpdateDate — datetime