took
Tables (3)
account
- account_seq — bigint — Primary key — NOT NULL
- main — bit(1)
- bank_seq — bigint — NOT NULL
- user_seq — bigint
- account_name — varchar(255)
- easy_pwd — varchar(255) — NOT NULL
bank
- bank_seq — bigint — Primary key — NOT NULL
- account_pwd — int
- bank_num — int
- is_bank — bit(1)
- balance — bigint
- account_num — varchar(255)
- own — varchar(255)
user
- user_seq — bigint — Primary key — NOT NULL
- alarm — bit(1) — NOT NULL
- image_no — int — NOT NULL
- lat — double
- lon — double
- simple_password — int
- created_at — datetime(6) — NOT NULL
- role — varchar(10) — NOT NULL
- birth — varchar(20) — NOT NULL
- phone_number — varchar(20)
- user_id — varchar(30)
- user_name — varchar(30)
- addr — varchar(100)
- email — varchar(255) — NOT NULL
- nickname — varchar(255)
- password — varchar(255) — NOT NULL
- gender — enum('F','M')
- login_status — enum('GOOGLE','KAKAO','TOOK') — NOT NULL